Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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'
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
Hi Thanks for the reply.
financial year is from Apr - Mar
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |