Power BI Require Run rate calculation

[Puneeth]

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 calculate 'No. of months passed from FY Start'

[Washivale]

Hi @Puneeth,

whats the FY start month in this case, is it Jan or March?

Also, if you could share sample data and desired output it would be great.

Regards,

Washivale

[Puneeth]

Hi Thanks for the reply.

financial year is from Apr - Mar

[Washivale]

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