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, Sorry if this has been asked before.. Please can some one help?
I have the below data in Power BI..
I want it to show the variance between any two periods when selected using two slicers for Period in Power BI.. thanks
Period | Forecast |
P03 | 7000 |
P03 | 8000 |
P02 | 15000 |
P02 | 56000 |
RF12 | 1000 |
RF12 | 25000 |
Solved! Go to Solution.
Hi @Anonymous ,
For this use case, I'd create two extra tables that hold the periods - these tables are disconnected(no relationship with) from the fact table - and then a measure for the variance.
Period1 =
DISTINCT ( Data[Period] )
Period2 =
DISTINCT ( Data[Period] )
Variance =
CALCULATE (
SUM ( Data[Forecast] ),
Data[Period] = SELECTEDVALUE ( Period1[Period] )
)
- CALCULATE (
SUM ( Data[Forecast] ),
Data[Period] = SELECTEDVALUE ( Period2[Period] )
)
sampel output -
sample pbix - https://drive.google.com/file/d/1HaM63-KmwyXdkhGt89hhvKkMMuPHrGv0/view?usp=sharing
Proud to be a Super User!
This is great, thank you so much.. you are a star!!
Hi @Anonymous ,
For this use case, I'd create two extra tables that hold the periods - these tables are disconnected(no relationship with) from the fact table - and then a measure for the variance.
Period1 =
DISTINCT ( Data[Period] )
Period2 =
DISTINCT ( Data[Period] )
Variance =
CALCULATE (
SUM ( Data[Forecast] ),
Data[Period] = SELECTEDVALUE ( Period1[Period] )
)
- CALCULATE (
SUM ( Data[Forecast] ),
Data[Period] = SELECTEDVALUE ( Period2[Period] )
)
sampel output -
sample pbix - https://drive.google.com/file/d/1HaM63-KmwyXdkhGt89hhvKkMMuPHrGv0/view?usp=sharing
Proud to be a Super User!
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 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |