Forum Discussion
Helper VLast Date output
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
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.
1 Reply
- Ashish_Mathur
Super User
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.