Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

sales analysis

Hello I have a following Power BI query to solve.   Tasks: 1. Data Import and Transformation: o Import the data into Power BI. o Create a relationship between the Region and Product tables....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    Ok that great. I got it now. Thanks Wenbin!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.