Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello experts,
I'm trying to get a rate (%) that will be the sum of Hours / Max value of Estimated filtered by Code "SR" for the latest month.
Here is a sample of my data.
I have been stuck here for hours... Any help is much appreciated.
Thank you
Solved! Go to Solution.
So for example, for July in your example data, this measure should return (.5+.75+.25)/9.96 = 15.06%?
Your measure would look like this:
SR Rate = CALCULATE( SUM(Table1[Hours]) / MAX(Table1[Estimated]), FILTER(Table1, Table1[Code] = "SR" && MONTH(Table1[Date]) = MONTH(NOW())-1)
So for example, for July in your example data, this measure should return (.5+.75+.25)/9.96 = 15.06%?
Your measure would look like this:
SR Rate = CALCULATE( SUM(Table1[Hours]) / MAX(Table1[Estimated]), FILTER(Table1, Table1[Code] = "SR" && MONTH(Table1[Date]) = MONTH(NOW())-1)
Hi @Cmcmahan
thank you vey much for your reply.
It did work indeed.
Could you please advice what I should change in the formula to get result for the previous month as well?
Thanks again!
July is the current previous month. On September first, this would calculate for August data.
If you want to change what month is being calculated, change the month filter criteria.
MONTH(Table1[Date]) = MONTH(NOW())-1
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |