cancel
Showing results for
Did you mean:
Regular Visitor

## How to find the variance between two parameters?

Spoiler
Edited.

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

1 ACCEPTED SOLUTION
Super User

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 -

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
2 REPLIES 2
Regular Visitor

This is great, thank you so much.. you are a star!!

Super User

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 -

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."

Announcements