Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
3 years ago
Solved

Power bi DAX

Hello guys i have a data set with this below table:-

But my required outcome should be like :-

Basically i want to get gen column with distinct area.
Thanks and Regrads..

Need Help
Show and Tell
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi BIswajit_Das ,

     

    I are the gen, st, and sc calculated columns or measures? or they already in your data?

     

    If they are already in your data, you can simply remove the duplicates in power query.

    If they are calculation, it will be summarized accordingly.

     

    Hope this helps

1 Reply

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    Hi BIswajit_Das ,

     

    I are the gen, st, and sc calculated columns or measures? or they already in your data?

     

    If they are already in your data, you can simply remove the duplicates in power query.

    If they are calculation, it will be summarized accordingly.

     

    Hope this helps