Forum Discussion
Solved
Creating Calculated Column based on the ID, and the most recent datetime column in DAX
I have the following 1K ++ records table in my PBI report with Virtual Machine's IDs and Scan date-time info: Table1 (this is a data snapshot, example) I need to create [QryDate_Upd] - cal...
Hell-1934 , Better to have date column first
Date = Datevalue([QryDate])
Then have columns like
Maxx(filter( Table1, [VMID] = earlier([VMID]) && [Date] = earlier([Date]) ), [QryDate])
Power BI DAX- Earlier, I should have known Earlier: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1
amitchandak
Super User
Super UserHell-1934 , Better to have date column first
Date = Datevalue([QryDate])
Then have columns like
Maxx(filter( Table1, [VMID] = earlier([VMID]) && [Date] = earlier([Date]) ), [QryDate])
Power BI DAX- Earlier, I should have known Earlier: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1