Forum Discussion

fer_vd's avatar
fer_vd
Frequent Visitor
9 years ago
Solved

Pivot table with multple dates on the same id

Hi, I'm still new to power BI and not too familiar with DAX. The situation is this: I have a table which contains all the changes to the state of an order. The same order can have multple changes on...
Need Help
  • mitsu's avatar
    mitsu
    9 years ago

    Following is what you can try  in the import data mode 

     

     

    1> Go to Query Editor .

    2> Pivot Column Status with value as Date and  in the advanced option select do not Aggregate .

     

     

     

     

    3> The colums should split by status with date as a value as shown below .

     

    4>You can then rename columns and perfrom the required date operations .

     

     

    Hope this helps 

     

     

     

    Regards,

    Mitsu

mitsu's avatar
mitsu
Resolver IV
9 years ago

Following is what you can try  in the import data mode 

 

 

1> Go to Query Editor .

2> Pivot Column Status with value as Date and  in the advanced option select do not Aggregate .

 

 

 

 

3> The colums should split by status with date as a value as shown below .

 

4>You can then rename columns and perfrom the required date operations .

 

 

Hope this helps 

 

 

 

Regards,

Mitsu

  • fer_vd's avatar
    fer_vd
    Frequent Visitor
    9 years ago

    Thank you Mitsu! This works. I've been struggling with this for too long and the answer is pretty easy once you know it.. So thanks a lot!

    I'll tag the topic as solved :).

     

    Fer