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,
I have a Time Intelligence calculation group with CY, PY, YoY, YoY %
The calculated group itself its fine, I made it with a tutorial and works with other measures, but not this one:
Solved! Go to Solution.
@Anonymous , have you created calculation groups in tabular editor?
then something is wrong, because when you take group name, you should see all 4
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
@Anonymous , This does seem like a calculation group?
This measure will give you CY when both CY and PY > 0 and CY > PY
Increase =
VAR CY = [Sales]
VAR PY = CALCULATE([Sales],SAMEPERIODLASTYEAR('Date'[Date]))
RETURN
SWITCH ( TRUE (),not(isblank(PY)) && PY > 0 && not(isblank(CY)) && CY > 0 && PY < CY, [Sales], BLANK ())
@amitchandak
Here is an image of 2 matrix
Both of them are using the Time Intelligence calculation group as columns, and Partner Names as rows
The one on the left uses Sales as Values
The one on the right uses the Increase meassure mentioned above
As you can see, with the Increase meassure, I can only see one column: CY
I need to see all the columns of the calculation group
@Anonymous , have you created calculation groups in tabular editor?
then something is wrong, because when you take group name, you should see all 4
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
@amitchandak I created the calculation group exactly as in the link you sent, with tabular editor.
It still does not work
@amitchandak Thank you, I'll take a look at the calculation groups again!
You are awesome!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |