Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am trying to create a measure that grabs the last date in the column StatusDateTime. All I get using MAX is the Date from the individual Row, but I need 11/17/20 to be the last date for each row as that is the date of the last StatusDateTime withing my time frame in my slicer.
VehicleID | City | StatusDateTime | PriorStatusDateTime | LastDate |
B1346 | SAN ANTONIO | 11/8/2020 14:37 | 10/20/2020 14:58 | 11/8/2020 14:37 |
B1346 | SAN ANTONIO | 11/10/2020 8:26 | 11/8/2020 14:37 | 11/10/2020 8:26 |
B1346 | SAN ANTONIO | 11/11/2020 21:56 | 11/10/2020 8:26 | 11/11/2020 21:56 |
B1346 | SAN ANTONIO | 11/17/2020 11:47 | 11/11/2020 21:56 | 11/17/2020 11:47 |
Would like it to look like this:
VehicleID | City | StatusDateTime | PriorStatusDateTime | LastDate |
B1346 | SAN ANTONIO | 11/8/2020 14:37 | 10/20/2020 14:58 | 11/17/2020 11:47 |
B1346 | SAN ANTONIO | 11/10/2020 8:26 | 11/8/2020 14:37 | 11/17/2020 11:47 |
B1346 | SAN ANTONIO | 11/11/2020 21:56 | 11/10/2020 8:26 | 11/17/2020 11:47 |
B1346 | SAN ANTONIO | 11/17/2020 11:47 | 11/11/2020 21:56 | 11/17/2020 11:47 |
Solved! Go to Solution.
@jeffw14 add following measure
Last Status Date = CALCULATE ( MAX( Table[Status Date], ALL() )
Or change ALL to ALLSELECTED in case you want to apply the filter to get the LAST DATE.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi I need Power query formula for this scenario, How did you get Max and Min date for each row?
VehicleID | City | StatusDateTime | PriorStatusDateTime | LastDate |
B1346 | SAN ANTONIO | 11/8/2020 14:37 | 10/20/2020 14:58 | 11/8/2020 14:37 |
B1346 | SAN ANTONIO | 11/10/2020 8:26 | 11/8/2020 14:37 | 11/10/2020 8:26 |
B1346 | SAN ANTONIO | 11/11/2020 21:56 | 11/10/2020 8:26 | 11/11/2020 21:56 |
B1346 | SAN ANTONIO | 11/17/2020 11:47 | 11/11/2020 21:56 | 11/17/2020 11:47 |
@jeffw14 add following measure
Last Status Date = CALCULATE ( MAX( Table[Status Date], ALL() )
Or change ALL to ALLSELECTED in case you want to apply the filter to get the LAST DATE.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Worked great, thank you.
User | Count |
---|---|
66 | |
61 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |