Variance Formula

[Anonymous]

Hello,

I am looking for assistance creating a formula to calculate the variance between two periods. I have created an example below. 

What I need is to write a formula comparing budget to each of the other period types. Essentially I would like to compare/show a variance comparing 2020 budget to 2020 6+6, 2020 7+5 and 2020 Forecast

Thanks!

Period	Dollars	Period (Budget - Other) Variance
2020 Budget	9953
2020 Forecast	8795
2020 1+11	4652
2020 2+10	7452
2020 3+9	5642
2020 4+8	4511
2020 5+7	3225
2020 6+6	7569

[Greg_Deckler]

@Anonymous - Did the answers provided by @ryan_mayu  and @DataInsights  meet your needs? If so, please mark an answer or @ me. Thanks.

[ryan_mayu · Accepted solution]

@Anonymous 

if you want to create a column , pls try

Column = MAXX(FILTER('Table','Table'[Period]="2020 Budget"),'Table'[Dollars])-'Table'[Dollars]

if you want to create a measure , pls try

Measure = SUMX(FILTER(ALL('Table'),'Table'[Period]="2020 Budget"),'Table'[Dollars])-sum('Table'[Dollars])

[DataInsights]

@Anonymous, try these measures:

2020 Budget = CALCULATE ( SUM ( Table[Dollars] ), Table[Period] = “2020 Budget” )

2020 6+6 = CALCULATE ( SUM ( Table[Dollars] ), Table[Period] = “2020 6+6” )

Variance - Budget vs 6+6 = [2020 Budget] - [2020 6+6]