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,
I have datainput in a special structure and I want to keep this structure
The timestamp per period in datainput is within one field.
Is there a possibilty to create a measure to display the deviation (%) between timestamp 2020 to 2021
for example within a powerbi-matrix ?
Kind regards and thanks
Rainer
Solved! Go to Solution.
I would go for table instead of matrxi in case more years will be added to input data.
For the table you can create the following 3 measures:
2020 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2020))
2021 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2021))
Deviation = ([2021] - [2020]) / [2020]
I would go for table instead of matrxi in case more years will be added to input data.
For the table you can create the following 3 measures:
2020 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2020))
2021 = CALCULATE(SUM('DataInput'[Sales]), FILTER('DataInput', 'DataInput'[time-stamp]=2021))
Deviation = ([2021] - [2020]) / [2020]
Thanks !
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |