Forum Discussion

GraceN's avatar
GraceN
Frequent Visitor
8 years ago

Get value from one month ago

Hi! I am new to Power BI, and I want to create a measure that returns a value corresponding to the previous month. I don't want to use a slicer. I think I want to use the CALCULATE function, but I do...
Need Help
WolfBiber's avatar
WolfBiber
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi,

try following formula:

YourMeasure = CALCULATE(SUM(TheTable[Actual]); PREVIOUSMONTH(TheTable[Month]))

 

Greetings,

Wolf

  • GraceN's avatar
    GraceN
    Frequent Visitor
    8 years ago

    Thanks, that partially worked. I created this measure, and I can see the last month's values in a new column in my table. 

     

    On the other hand, I only want a scalar result that reflects the Actual or Target value for the previous month (rather than a new column of values). That is, I want the measure to show Actual_last_month = 52 and Target_last_month = 55

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Did you try the suggestion by WolfBiber?  That uses a calculated measure so may be better suited to this

      • GraceN's avatar
        GraceN
        Frequent Visitor
        8 years ago

        Yes, I tried that. Please see my response in the previous message.