Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the opposite of EOMONTH() in Power BI (DAX)

Tags:

powerbi

dax

m

What is the opposite of EOMONTH()? I am trying to find the beginning date of 12 months ago. Would it be EOMONTH(Current Date,12)-1?

Any direction would be great. TIA

like image 522
Zornjac Avatar asked Dec 14 '22 14:12

Zornjac


1 Answers

To find the beginning of a month, go to the end of the month before and add a date to it (not sure if I understand the question)

Start of month one year ago = EOMONTH(TODAY(),-13)+1
like image 68
Trubs Avatar answered Jan 23 '23 18:01

Trubs