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, 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 |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |