- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Help with new Measure
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-01-2017 08:59 PM - edited 03-01-2017 09:02 PM
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.
Accepted Solutions
Re: Help with new Measure
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-02-2017 12:50 AM
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
Power Query Buch online auf http://www.powerbi-pro.com
All Replies
Re: Help with new Measure
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-02-2017 12:50 AM
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
Power Query Buch online auf http://www.powerbi-pro.com
Re: Help with new Measure
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-02-2017 11:32 AM - edited 03-02-2017 11:53 AM
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.