The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a dataset containing machine inventory details, including owner information and power consumption. When a machine stops, the owner field is left blank, and power consumption is set to zero. For instance, Machine 4 stopped on May 2nd, which is why its owner field is blank and its consumption is zero. Similarly, Machine 5 stopped on May 3rd, resulting in a blank owner field and zero consumption.
When I plot the data in a matrix, the owner field is repeated twice for Machine 4 and Machine 5, likely due to two variations in the owner data.
I would like to display the most recent non-blank owner information for these machines in the Owner field. For instance, Machine 4 should show Owner4, and Machine 5 should show Owner5 like below
Can anyone sugesst how to show this? Any help is really appreciated.
Thanks!
Solved! Go to Solution.
Hi @subhendude
Maybe it is not the most elegant way, but it works 🙂
You can create 2 calculated columns :
1. For last nonblank date for every machine :
2. For the owner in this date
Now, you can use the calculated owner in your visuals:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi,
In the Query Editor, use the "Fill down" feature on the Owner column
Hi @subhendude
Maybe it is not the most elegant way, but it works 🙂
You can create 2 calculated columns :
1. For last nonblank date for every machine :
2. For the owner in this date
Now, you can use the calculated owner in your visuals:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
81 | |
62 | |
54 |
User | Count |
---|---|
249 | |
119 | |
115 | |
94 | |
70 |