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,
I want do something with PowerPivot/DAX for designing a model that can calculate a composition of existing measuring points.
I explain my setup a little
The meter_id's are like m0001, m0002, ....
The expression of the composition in the third table can be in different forms like:
"m0001 + m0002", or "m0001/(m0001+m0002)*m0003", or "m0004 + m0005 - m0006", ...
Does anyone has suggestion on how to handle this case?
Can I make a DAX measure where this column with the "expression of composition" is converted to a formula that gets its data from the all monitored data table?
Thanks,
Hi @fceusters
Can you please share some actual data.
Qs: If your expresson is m0001 + m0002, how do you know which value for m0001 and m0002 to use? Does each meter ID appear only once in the meter_id column?
Regards
Phil
Proud to be a Super User!
Hi Phil,
Tanks for the quick respons,
These meter_ID's are connected to to the table with all monitored data ("SQL")
A sample file with randomized data, and only an example meters structure you can find in:
Let me know if I can explain more
Regards,
Frank
Hi @fceusters ,
Seems that not certain what is your expected output based on your description.
Could you please consider combining it with your sample data or some screenshots about your expected output in the table for further discussion so that members in the community could help you better.
Best Regards,
Community Support Team _ Yingjie Li
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.
User | Count |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |