The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, Newbie question.
I have 2 queries from two datasources. I can merge these 2 queries and display the result like this
Cat, Value from T1 Value from T2
Cat1 100 110
Cat 2 100 100
Cat 3 120 100
I want to add column Delta which should be Value fromT2 - Value from T1
Then filter on that to retain Delta <> 0
Seems simple but I cannot get it to work.
Solved! Go to Solution.
@hi @Anonymous
Table Structure and Relationship
Create a measure "Delta"
"This is table Values and Visual Filter
@hi @Anonymous
Table Structure and Relationship
Create a measure "Delta"
"This is table Values and Visual Filter
thanks Victor, this works fine and get me started.
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |