Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello there,
I'm kind of new in Power BI, and I was wondering if is it possible to create a new measure using two variables of two different query's. I took the EdX course, but I don't remember to have an exercise like this.
For sure, if this is possible I will appreciate the advice of how to do it. Step by step likely. Hope someone sees my question and answer it.
The function that I need to do is a difference. Variable A, subtract Variable B (A-B).
Best regards.
Solved! Go to Solution.
Hi Josepatwentysix
I'm not sure if I fully understood your question, but I'll try to answer the question.
You have to create 3 measures in PBI Desktop.
1. Measure:
FirstMeasure = sum(Tabelle1[A])
2. Measure:
SecondMeasure = sum(Tabelle1[B])
Difference Measure:
Difference = [FirstMeasure] - [SecondMeasure]
Greetings
Hp Pfister
Measure A: calculate something
Measure B: calculate something
Measure Difference: = A - B
Hi Josepatwentysix
I'm not sure if I fully understood your question, but I'll try to answer the question.
You have to create 3 measures in PBI Desktop.
1. Measure:
FirstMeasure = sum(Tabelle1[A])
2. Measure:
SecondMeasure = sum(Tabelle1[B])
Difference Measure:
Difference = [FirstMeasure] - [SecondMeasure]
Greetings
Hp Pfister
Measure A: calculate something
Measure B: calculate something
Measure Difference: = A - B
Of course, that's what I've learned already when both varibles correspond to the same Query. I was talking more like when one variable is from one Query or folder, and the other variable is from a different Query or folder.
But if you wanted to say Tabelle1 and Tabelle 2, I guess you right, I'm gonna try with your explanation and promote you to solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.