Forum Discussion

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
6 years ago
Solved

Finding column values based on two different Values of same table

Hi, I have below table in my dataset   Id EventType Date cid 1 a 2020-05-01  2 2 b 2020-05-02   3 a 2020-05-02 4 4 b 2020-05-01    5 c 2020-05-03    step 1 ...
Need Help
  • PBILover's avatar
    PBILover
    6 years ago

    Yor are Awesome Kelly!!
    It Works!!

    Now user Wants to display data as in below format

     

    ididDateCidCidDateDate Diff
    14/08/2020 7:59:51 PM24/08/2020 6:26:20 PM5611
    34/08/2020 8:03:47 PM44/08/2020 8:03:47 PM0


    Will it be Possible?

    I am exploring some options.

    Thank you very much for your help.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

PBILover yes it can be done, you need a separate table with unique event type values, it will be purely used for slicing from there you can write a measure to find out all the ids

 

 

 

  • PBILover's avatar
    PBILover
    Icon for Helper V rankHelper V
    6 years ago

    parry2k can you please little elaborate it more, sorry i am not that good in power BI yet.