Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have a table in PowerPivot with Month, Quarter,Product and Actual for 3 years data. I need a calculating column or Measure which calculates percentage of Month. It needs to calculate as Sum of the Total Month/Sum of the Quarter.
Is it possible? Please help
Thanks & Regards,
Mahesh
Can someone helpme out in the formula
Hi @mahirk,
I create the sample data table which including date and sales for each day.
I create calculated columns to get year, quarter and month.
Year = YEAR(Test1[Date]) Quarter = ROUNDUP(MONTH(Test1[Date])/3, 0) Month = MONTH(Test1[Date])
Create a calculating column which calculates percentage of Sum of the Total Month VS Sum of the Quarter.
Percentage = CALCULATE(SUM(Test1[Sale]),ALLEXCEPT(Test1,Test1[Month]))/CALCULATE(SUM(Test1[Sale]),ALLEXCEPT(Test1,Test1[Quarter]))
Finally create a table to display the result.
If you have other issues, please let me know.
Best Regards,
Angelia
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
90 | |
71 | |
69 |
User | Count |
---|---|
228 | |
128 | |
117 | |
83 | |
82 |