Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI Everyone ,
Can you help me on this , I have below tables , i'd like my File to run as 18 Jan , 27 jan , 30 jan in another new Column as date Column and show only the specific qty which has in each description in power BI , for others No Value , turn to 0 Value.
Can anyone tell me how to do this ? I have hundreds of columns as date.
and i wanna use below in Power BI which i can get further analyze
Solved! Go to Solution.
Hi @Chanleakna123,
You can Unpivot these three columns. If you want more help, please post the result you want.
Best Regards,
Dale
Hi @Chanleakna123,
You can Unpivot these three columns. If you want more help, please post the result you want.
Best Regards,
Dale
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |