Forum Discussion

bmk's avatar
bmk
Icon for Helper II rankHelper II
2 years ago
Solved

Previous Month DAX Calculation

I seem to be running into a road block and I think this may be straightforward. If someone can please help.    I am using a table visual on PBI, with a bunch of measures. I have a date table. I wis...
Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    bmk 

    Add calculated column as follows:

    Previous Month = INT('Date Table'[Date] IN CALENDAR( EOMONTH( TODAY() , -2)+1 , EOMONTH( TODAY() , -1) ))


    I suggest you modify your calender table date range as follows, not to have too many dates/rows. I entere 10 years back so you can chagne it in terms of years:

    ADDCOLUMNS (
    CALENDAR (
    DATE ( YEAR ( today() ) - 10 ) ,1 ,1 ),
    DATE ( YEAR ( today() ),12 ,31 ),




bmk's avatar
bmk
Icon for Helper II rankHelper II
2 years ago

Thank you, Adam.