Search code examples
powerbim

Power BI How to find the end date of a month Q

I have the start of every month in a table. What I am wanting to know is, how do you find the last day of the month if you have the starting month?

In other languages I would take the start date of a month, add a month and then subtract 1 day. How do you do this in Power BI?

In my example below, you will see the starting month in the Month field.

enter image description here

Solution

  • You can use EOMONTH function to calculate that.

    =EOMONTH([Month], 0)