Forum Discussion
sshiny
Helper II
Helper IIHow to get the latest date
PFA the data sample. In the last order date , I need a single value-the last order date for the particular tag
Hi sshiny
Create a new column with the following code. This will give you the last order date for every tag.
Last Order Date = CALCULATE(MAX('Table'[Order Date]),ALLEXCEPT('Table','Table'[Tag ID]))Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
- amitchandak
Super User
sshiny , Try the approach in my blog
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
v-jingzhangCommunity Support
Hi sshiny
Create a new column with the following code. This will give you the last order date for every tag.
Last Order Date = CALCULATE(MAX('Table'[Order Date]),ALLEXCEPT('Table','Table'[Tag ID]))Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
