Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Calculating Rate

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
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello erhan_79 

    Give this a try.

    Rate = 
VAR _Date = MAX ( YourTable[Report Date] )
VAR _Act = CALCULATE ( COUNTROWS(YourTable), YourTable[Report Date] = _Date, YourTable[Status] = "Actual Month" )
VAR _ActNext = CALCULATE ( COUNTROWS(YourTable), YourTable[Report Date] = _Date )
RETURN 
DIVIDE ( _Act, _ActNext )

     

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Hello erhan_79 

Give this a try.

Rate = 
VAR _Date = MAX ( YourTable[Report Date] )
VAR _Act = CALCULATE ( COUNTROWS(YourTable), YourTable[Report Date] = _Date, YourTable[Status] = "Actual Month" )
VAR _ActNext = CALCULATE ( COUNTROWS(YourTable), YourTable[Report Date] = _Date )
RETURN 
DIVIDE ( _Act, _ActNext )