Column name to show date of prior month that when report is running

[danielcarreira1]

Hi all,

I am very new to PowerBI but i am building a report where one of the columns has to show the date in the format 'yyyy-mm-dd' for the prior month of when it's running, so if in march 2021 should show the first day of February 2021 in the format referred previously.

Appreciate assistance.

Best Regards,

Daniel

[v-alq-msft · Accepted solution]

Hi, @danielcarreira1 

Based in your description, I created data to reproduce your scenario. The pbix file is attached in the end. 

Table:

You may create a calculated column or a measure as below.

Calculated column:

Result Column = EOMONTH([Date],-2)+1

Measure:

Result Measure = EOMONTH(SELECTEDVALUE('Table'[Date]),-2)+1

Result(You can modify the format in 'Column tools'):

Or you may go to 'Query Editor'm create a custom column with the following m codes.

Date.AddDays( Date.EndOfMonth( Date.AddMonths([Date],-2) ),1)

Then you can modify the format as you want in Power BI Desktop. Here is the result.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@danielcarreira1 , You can try measure like

eomonth(max(Date[Date]),-2)+1

or

eomonth(today(),-2)+1