use if to find difference between columns from specific date

[Anonymous]

Hello, i want to find varriance = sum( tableA[cost]) - sum(tableB[cost]) .

i have data from before 2022, i want to use the varriance to calculate from 2022-01-28 until now while anything before just give me a 0 . so im assuming i use the if synatx?

any help?

[Anonymous]

Hi @Anonymous ,

Do both table A and table B have a date column? If so, please have a try.

Create a measure.

measure=var _a=calculate(sum(tableA[cost]),filter(all(tableA),tableA[date]>=date(2022,1,28))
var _b=calculate(sum(tableB[cost]),filter(all(tableB),tableB[date]>=date(2022,1,28))
return
_a-_b

If I have misunderstood your meaning, pelase provide more details with your desired output and sample data without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nathaniel_C]

Hi @Anonymous ,

Try this 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Variance =
var _date = tableA [date]
var _TAsum = MAX( tableA[cost]) 
var _TBsum = MAX(tableB[cost])

Return If( _date > 1/27/2022,_TAsum-_TBsum, 0)

//assumes dates match between TableA and TableB drop this on your table visual, calcs row by row

[Anonymous]

it didnt work for me