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 calculate the rate " Amount"of report for last day on report .

Amount  (summarized ) on status "Actual Monh " total and between "Actual Month + Next Month " Total  ,

 

 

i tried to explain below picture what i need , i hope it is clear , thanks in advance for your kind supports 

 

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.

1 Reply

  • 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.