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.
Hello everyone, I'm trying to build below chart in power BI. I need to have PY values, then CY year break down by quarters. Noting that Yearly Average is coming from a column in a table that is different from quarterly Average colmn in the same table.
Any ideas please?
Solved! Go to Solution.
Hi @ritanoori,
One sample for your reference.
1. Create a date table and create relationship between it and the fact table.
Table = CALENDARAUTO()
2. Create the measures as below.
Average = CALCULATE(AVERAGE(Table1[value]))
Measure = CALCULATE(SUM(Table1[value]),SAMEPERIODLASTYEAR('Table'[Date]))
For more details, please check the pbix as attached.
Regards,
Frank
Hi @ritanoori,
One sample for your reference.
1. Create a date table and create relationship between it and the fact table.
Table = CALENDARAUTO()
2. Create the measures as below.
Average = CALCULATE(AVERAGE(Table1[value]))
Measure = CALCULATE(SUM(Table1[value]),SAMEPERIODLASTYEAR('Table'[Date]))
For more details, please check the pbix as attached.
Regards,
Frank
Hi @ritanoori ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |