Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
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
Proud to be a Super User!
it didnt work for me
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |