Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I want to create a table in order to compare two values from separate datasets. The datasets are shown in the below picture.
I don't have any problems with the datasets individually but creating a single table not seems possible. To create a relation in order to create a single table, I related the datasets through the date data.
That helped me to get the two datasets to a single table but now some of the parameter values (highlihted values in the below picture) are duplicated for other equipments. I know additional relation between the equipments are required but I couldn't manage to build a relationship. I created a reference table for the equipments and relate it to the both datasets but again that did not help.
Do you have any suggestions to create a relationship between the equipments table? Thank you for your time.
Solved! Go to Solution.
Hi @Anonymous ,
You may consider use merge queries in power query editor:
transform data -->merge queries as new --> expand column and rename columns
result:
Or please new a measure like:
Second dataset =
VAR _date= MAX('Table1'[Date])
VAR _equipment = MAX('Table1'[Equipment])
VAR _result = CALCULATE(SUM('Table2'[Parameter]),'Table2'[Date]=_date&&'Table2'[Equipment]=_equipment)
RETURN
_result
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Anonymous ,
You may consider use merge queries in power query editor:
transform data -->merge queries as new --> expand column and rename columns
result:
Or please new a measure like:
Second dataset =
VAR _date= MAX('Table1'[Date])
VAR _equipment = MAX('Table1'[Equipment])
VAR _result = CALCULATE(SUM('Table2'[Parameter]),'Table2'[Date]=_date&&'Table2'[Equipment]=_equipment)
RETURN
_result
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
That worked! Thank you so much
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |