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

General Comment
Need Help
Show and Tell

3 Replies

  • Washivale's avatar
    Washivale
    Resolver V
    8 years ago

    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'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