Forum Discussion
UIUser
1 year agoFrequent Visitor
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...
Anonymous
1 year agoNot applicable
Hi UIUser ,
We recommend using the ADDCOLUMNS function combined with MAXX to calculate the maximum date directly within the virtual table context. This approach avoids the limitations of the ALL function with virtual tables.
Best regards,
Lucy Chen
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.