topic Re: use if to find difference between columns from specific date in DAX Commands and Tips

use if to find difference between columns from specific date

Anonymous — Mon, 23 May 2022 21:31:50 GMT

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?

Re: use if to find difference between columns from specific date

Nathaniel_C — Tue, 24 May 2022 01:43:10 GMT

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

Re: use if to find difference between columns from specific date

Anonymous — Tue, 24 May 2022 06:02:34 GMT

it didnt work for me

Re: use if to find difference between columns from specific date

Anonymous — Thu, 26 May 2022 08:52:43 GMT

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.