Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all.
From the screenshot shown above, I would like to filter the serial number first before proceeding to calculate the difference in the higest and lowest voltage within each serial number. Is there a possible way in achieving the above mentioned outcome? Relatively new to power BI so I am quite unsure with how to approach this problem. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi,
I assume you want to create a calculated column.
Please check the below picture and the attached pbix file.
Diff calculated column =
MAXX (
FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
Data[Voltage]
)
- MINX (
FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
Data[Voltage]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I assume you want to create a calculated column.
Please check the below picture and the attached pbix file.
Diff calculated column =
MAXX (
FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
Data[Voltage]
)
- MINX (
FILTER ( Data, Data[Serial No] = EARLIER ( Data[Serial No] ) ),
Data[Voltage]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
15 | |
14 | |
12 | |
9 |