Forum Discussion
Values by month
I have a matrix set up like so
june
orders
sales
income
july
orders
sales
income
and so on with the months of the year. I want to organize it like this though
orders
june
july
august
september
and so on with the rest of the months, then the next account, sales, to do the same thing. does anyone know how to organize a matrix in such way?
Step 0: I use this data table. (Date: yyyy/mm/dd)
Step 1: I fill down the 'Date' column on Power Query Editor.
- Before -
- After -
Step 2: I filter the 'Class' column on Power Query Editor.
- Before -
- After -
Step 3: I click 'Close & Apply' on Power Query Editor.
Step 4: I make a matrix on Power BI Desktop.
2 Replies
Step 0: I use this data table. (Date: yyyy/mm/dd)
Step 1: I fill down the 'Date' column on Power Query Editor.
- Before -
- After -
Step 2: I filter the 'Class' column on Power Query Editor.
- Before -
- After -
Step 3: I click 'Close & Apply' on Power Query Editor.
Step 4: I make a matrix on Power BI Desktop.
usually you only need to create measures and add measures to the matrix. Could you pls provide some sample data and the expected output?
