DAX Measure to compare against prior version RRS feed

  • Question

  • I need a DAX measure that compares latest version of   financial data against prior version.

    My data table has an ‘ASofDate’ column to tag which   version of the data it is (100K+ rows)

    For example I would like to compare the full year 2019   Cash number as of September vs. the full year 2019 cash number as of August

    The formula I gave been using isnt working as its giving   me the sum of that months cash only

    =CALCULATE([Total Cash],DATESINPERIOD(Consolidated_PTS[As   of Date],LASTDATE(Consolidated_PTS[As of Date]),-1,month))

    Can anyone recommend a solution?

    Wednesday, September 18, 2019 4:50 PM