Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |