Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Calculating Rate by summary

Hi there ;   İ would like to calculate below issue could you pls help me , let me explain pls sceneraio  first :    i have a table as below which one you can see at left below ; i would like to c...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    erhan_79 

     

    Please try below measure

    Measure 2 = 
var maxdate=MAX('Table (3)'[repotdate])
var actual=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate&&'Table (3)'[status]="actual"))
var actualnext=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate))
return actual/actualnext

    Hope this is helpful.

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

erhan_79 

 

Please try below measure

Measure 2 = 
var maxdate=MAX('Table (3)'[repotdate])
var actual=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate&&'Table (3)'[status]="actual"))
var actualnext=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate))
return actual/actualnext

Hope this is helpful.