Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Need Help in DAX

 

 

Hi 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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi baskar,

     

      do you want augmented result of all 4 columns in one single column with "-" as separator ??

     

    Regards

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      No, I want distinct. I mention as output rows

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Baskar

     

    In this scenario, using DISTINCT function should meet you requirement. See my sample below.

     

    I assume you have a table called MyTestTable like below.

    Then you should be able to use the formula below to create a new calculate table MyDistinctTable contains distinct values from MyTestTable.

    MyDistinctTable = DISTINCT ( MyTestTable )

     

    Regards