Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |