Forum Discussion

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Try this MEASURE

 

Measure =
VAR lastmonth =
    MONTH ( LASTDATE ( Table1[Revenue_Date__c] ) )
VAR lastyear =
    YEAR ( LASTDATE ( Table1[Revenue_Date__c] ) )
RETURN
    CALCULATE (
        SUM ( Table1[Revenue_Amount__c] ),
        YEAR ( Table1[Revenue_Date__c] ) = lastyear
            && MONTH ( Table1[Revenue_Date__c] ) = lastmonth
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Zubair_Muhammad Not quite. It just matched the grand total of Revenue Column:

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Hi Anonymous,

       

      Zubair_Muhammad's solution should work for you.

       

      Then based on your screenshot, it seems like you are creating a calculated column not a measure. Right? Please refer to following sample, and you can find out the difference between calculated column and measure. 

       

      By the way, they are using the same expression:

       

       

      Thanks,
      Xi Jin.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        v-xjiin-msft not sure what I'm doing wrong: