Forum Discussion
Solved
DAX LastDate? Problem
Hi, I wonder if someone can help me get past this road block. I have tried so many options (mainly around virtual tables and dax last date) I think my approach must be wrong. I have two tables; ...
hi kavster
I think the best way is to first create a summarized table :
last_date_table_period = SUMMARIZE(
'Periods and Weeks','Periods and Weeks'[FY-Period],"last_date", LASTDATE('Periods and Weeks'[Date]))after that you add a coulmn in the full_schedule_data :last_date = LOOKUPVALUE(
last_date_table_period[last_date],last_date_table_period[FY-Period],Full_Schedule_Data[Period_FY]
)Did I answer your question? Thanks to mark my post as a solution 😁Yep, you nailed it. Brilliant thank you for the help, works perfectly.
hi kavster
I think the best way is to first create a summarized table :
last_date_table_period = SUMMARIZE(
'Periods and Weeks','Periods and Weeks'[FY-Period],"last_date", LASTDATE('Periods and Weeks'[Date]))
'Periods and Weeks','Periods and Weeks'[FY-Period],"last_date", LASTDATE('Periods and Weeks'[Date]))
after that you add a coulmn in the full_schedule_data :
last_date = LOOKUPVALUE(
last_date_table_period[last_date],last_date_table_period[FY-Period],Full_Schedule_Data[Period_FY]
)
last_date_table_period[last_date],last_date_table_period[FY-Period],Full_Schedule_Data[Period_FY]
)
Did I answer your question? Thanks to mark my post as a solution 😁
Yep, you nailed it. Brilliant thank you for the help, works perfectly.