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 l...
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.
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.