Forum Discussion
sales analysis
Hi Anonymous ,
I don't think it's necessary if there's no clear need for it. Pivoting affects the creation of visuals.
You just need to make sure the data is arranged in this way.
Best Regards,
Wenbin ZhouOk that great. I got it now. Thanks Wenbin!
Hi Anonymous ,
1.Regarding your question, you should have completed this part of the task.
2.
You can do pivot and unpivot here.
3.
You can create similar DAX expressions using the 'TOTALYTD' function.
TOTALYTD function (DAX) - DAX | Microsoft Learn
Column = TOTALYTD(SUM('Table'[Amount]),'Table'[Date].[Date],ALLEXCEPT('Table','Table'[Region]))
4.
Use the following DAX expression to create a measure.
Measure = SUM('Table'[Amount])
5.
The Table data is shown below:
Use the following DAX expression to create a measure
Measure =
CONCATENATEX(FILTER('Table','Table'[Amount] = MAX('Table'[Amount])),[Product],",")CONCATENATEX function (DAX) - DAX | Microsoft Learn
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Thanks for your reply.
Regarding unpivot and pivot I know how to do it. But I don't understand what to pivot .
Also I don't understand the reason behind doing unpivot and pivot in this data. Is it necessary here ?Could you please explain?
Hi Anonymous ,
As I understand it, pivot just lets you look at the data from another angle.
If you perform a pivot operation in Power query, it is not conducive to building visuals in Power BI Desktop, so perform an unpivot operation.
You don't seem to have performed a pivot operation in your step, and a unpivot operation seems to be unnecessary.
Best Regards,
Wenbin ZhouAhh I see. But is pivoting necessary ?
Hi Anonymous ,
I don't think it's necessary if there's no clear need for it. Pivoting affects the creation of visuals.
You just need to make sure the data is arranged in this way.
Best Regards,
Wenbin Zhou