Forum Discussion
Anonymous
2 years agoNot applicable
Making a single row with multiple new columns
Hi, I have an SQL extract that produces a table forecasting the dates for mainteance events but it produces a row for each event, with a single week-year that the activity would take place. I would l...
- 2 years ago
Hi Anonymous ,
Yo can Pivot the Week by Type.
Buuuuut. It is advisable to have more columns than to have more columns
Why do you need to do this kind of step in M query?
If you just want to show the data by week, you can use the matrix visual instead of doing it here
mussaenda
2 years agoCommunity Champion
Hi Anonymous ,
Yo can Pivot the Week by Type.
Buuuuut. It is advisable to have more columns than to have more columns
Why do you need to do this kind of step in M query?
If you just want to show the data by week, you can use the matrix visual instead of doing it here