Forum Discussion

tahir9's avatar
tahir9
Frequent Visitor
8 years ago
Solved

Getting prior month data to display for current month?

Hello i am trying to display the prior month totals as a measure in a table where i am showing the totals by month and year... but my measure formula isn't working not sure why? Here is the formula: ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI tahir9

     

    Please try this calculated measure

     

    Prior days = 
    CALCULATE(
        SUM('Calendar'[Work Day]),
        ALL('Calendar'),
        PREVIOUSMONTH('Calendar'[Date])
        )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI tahir9

 

Please try this calculated measure

 

Prior days = 
    CALCULATE(
        SUM('Calendar'[Work Day]),
        ALL('Calendar'),
        PREVIOUSMONTH('Calendar'[Date])
        )
tahir9's avatar
tahir9
Frequent Visitor
8 years ago

that worked Phil! Thank you! Just curious if you could explain why that worked but my method did not... ?