Forum Discussion
Create a table/matrix using columns from data model as rows based on a condition.
Create a table/matrix using columns from data model as rows and display corresponding values segregated as Total, Quarter 1, Quarter 2, etc. For example, I have two columns in my dataset - IceCrea...
Hi Anonymous
If you require the Quarter as the column per your post, then I suggest changing the Quarter from a measure to a calculated column or create a Date table (which would be more aligned to better practice). You can use this link SQLBI Date Table.
Hope this helps 🙂
Theo
Hello TheoC ,
Thank you for the response.
The Quarter is a measure created in the model. It's not getting added in the Column section of matrix.
Hi Anonymous
If you require the Quarter as the column per your post, then I suggest changing the Quarter from a measure to a calculated column or create a Date table (which would be more aligned to better practice). You can use this link SQLBI Date Table.
Hope this helps 🙂
Theo