Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all...
I want to convert the Months ie., [columns] Apr, May, June etc... into rows with out unpivoting the table... [ I have almost 6.5 lakh records of multiple sheets combined as a single sheet using query. when converting it takes a lot of time and during refresh also it takes lot of time]
OR
I want to insert month number into a calculated column ie., a new column as month number and values Apr means 4, May means 5 etc..
Is it possible?
My same data
YEAR | SHORTNAME | DEALER | TYPE | PRODUCT | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | TOT | CATEGORY |
20182019 | AB | A | STD | PROD | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | PRODUCT |
20182019 | AC | B | STD | PROD | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | PRODUCT |
20182019 | AD | A | STD | PROD | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | PRODUCT |
20182019 | AB | A | STD | CAB | 0 | 40 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | CAB |
20182019 | AB | A | STD | CAB | 0 | 50 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | CAB |
20182019 | AC | A | STD | CAB | 0 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 450 | CAB |
20182019 | AD | A | STD | CAB | 0 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 450 | CAB |
20192020 | AB | A | STD | PROD | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | PRODUCT |
20192020 | AC | B | STD | PROD | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | PRODUCT |
20192020 | AD | A | STD | PROD | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | PRODUCT |
20192020 | AB | A | STD | CAB | 0 | 40 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | CAB |
20192020 | AB | A | STD | CAB | 0 | 50 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60 | CAB |
20192020 | AC | A | STD | CAB | 0 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 450 | CAB |
20192020 | AD | A | STD | CAB | 0 | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 450 | CAB |
Regards
Ravikumar.S
In the matrix table, you can outcome like that. Any specific reason you want to store data into another table like that.
@amitchandak wrote:In the matrix table, you can outcome like that. Any specific reason you want to store data into another table like that.
YES... NEED TO put month in a Slicer for selection and workout things...
Hi,
If you want a single month slicer, you will have no option but to use the "Unpivot Other columns" feature.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |