Forum Discussion
Max Date over virtual table
Hi, I needed to create a virtual table with a start_of_month date and cancellations. I now need to obtain in a third column the max date for start_of_month. However, I'm only getting the same da...
hi UIUser ,
I think this can help, please try it and let me know:
max_date =
CALCULATE(
MAX(myTable[start_of_month]),
ALL(myTable)
)
Bibiano_Geraldo No it doesn't work. I can't use my virtual table in the ALL clause. It won't let me select it. I guess it's because ALL can not be used with virtual tables.