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 replicate a calculation I have in excel into Power BI.
Long story short, I have a table which display what the performance is for each month (see screen shots) and a second column YTD where it displays the performance depending on the month.
i.e. If we had 100% in July and 120 % in August, then the YTD column would display 100% for July and 110% for August as August is the sum of July and August percentages divided by 2.
Then if it was september, it would be divided by 3 and so on.
I know how to create this calculation in Excel, but would any of you know how to do in Power BI?
See screen shots
Solved! Go to Solution.
@RodrigoTXRAHere is something I put together to give you an idea, logically you should have a FIscal Date DImension in model for time intelligence and this kind of calculation, but I guess this will get you started.
Cheers!!!
P
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |