Forum Discussion
Direct query - matrix - days until today
Anonymous , Direct Query mode also you can have columns but there are limitations.
In the case of SQL Server, it allowed creating a new column like
Column = DATEDIFF([Sales Date],today(),day)If you want the measure to display as a column/row, You need to have an independent table and create a measure that joins this measure and that table using some group by level
refer video - https://www.youtube.com/watch?v=CuczXPj0N-k
Anonymous , Direct Query mode also you can have columns but there are limitations.
In the case of SQL Server, it allowed creating a new column like
Column = DATEDIFF([Sales Date],today(),day)
If you want the measure to display as a column/row, You need to have an independent table and create a measure that joins this measure and that table using some group by level
refer video - https://www.youtube.com/watch?v=CuczXPj0N-k
Thank you very much! I don't know why every resource I read told me I could only add column in Import mode.