Forum Discussion

Puneeth's avatar
Puneeth
Frequent Visitor
8 years ago

Power BI Require Run rate calculation

Hi all,   i'm trying to Calculate Required Run Rate per month ---   formula => (OB Achieved / No. of months passed from FY Start)   from above formula OB Achieved is calculated but how do i cal...
General Comment
Need Help
Show and Tell
Puneeth's avatar
Puneeth
Frequent Visitor
8 years ago

Hi Thanks for the reply.

 

financial year is from Apr - Mar

Washivale's avatar
Washivale
Resolver V
8 years ago

Hi Puneeth,

 

Assuming you have a date column in your Date, you can create a measure as below:

 

OB Achieved by Month YTD = Divide([OB Achieved], (Month([Date])-4))

 

let me know if it works.

 

Thanks