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 everyone,
I have the following table:
As you can see the dates are not ordered. However, if I now want to have the current status output, I either get an 'N' or an blank field. So the first or the last data record.
How can I only output the current last data record, here in the example it would be from 07/28/2022 -> 231.
Last:
First:
Thank you for help
Solved! Go to Solution.
Hi,
In the Query Editor, seperate the Date and Time into 2 columns. Create a Calendar Table and build a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table. To your visual, drag Name from the Data Table. Write these measures
Date value = sum(Data[Date])
Nr at farthest date = calculate(max(Data[Nr]),datesbetween(Calendar[Date],[Date value],[Date value]))
Hope this helps.
Hi,
In the Query Editor, seperate the Date and Time into 2 columns. Create a Calendar Table and build a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table. To your visual, drag Name from the Data Table. Write these measures
Date value = sum(Data[Date])
Nr at farthest date = calculate(max(Data[Nr]),datesbetween(Calendar[Date],[Date value],[Date value]))
Hope this helps.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |