Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Need Help

Thanks Advanced.

 

 

The Screen in my input .

 

Expected result is 

 

Sep-16  - India  - Airoli - 10

Oct-16  - India  - Airoli - 20

 

How can i do with Dax ?

 

am clueless !!!

 

Greg_Deckler ankitpatira Anonymousv-haibl-msft

1 Reply

  • ryan-gao's avatar
    ryan-gao
    Helper III
    9 years ago

    summarize(Table,Table[Date],Table[Geo],Table[City],"Values",Calculate(Values(Table[Value])))