Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Table in DAX expression

Hello All, I have the below dataset of products and store information. I would like to have a simple DAX Expression which returns Product and total sales. Main Dataset: City Product A ...
DAX
Table
AnkitKukreja's avatar
AnkitKukreja
Super User
5 years ago

Hi Anonymous 

 

I believe calculate table or unpivot is the only option according to me.

Let's see if we can get any other solution.

 

Thanks,

Ankit

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate table will have an issue of static data. Because it won't have dynamic data. Unpivot is also a one-time solution and the same challenge of static data. Thanks, Ankit for looking into though.

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    5 years ago

    Hi Anonymous 

    But, unpivot would be added as a step in your query editor and it would update as your data is updated everytime. Just thinking it out loud, if you might have missed that point.
    Anyways, thanks and good luck.