Forum Discussion

klehar's avatar
klehar
Helper V
4 years ago
Solved

Bring/Combine 2 dates on the same column

Hi,   I have a sample data that looks like this:   Opportunity ID HW Date Hardware Order($M) SW Date Software Order($M) OPE123 1/1/2021 45 1/1/2021 70 OPE124 1/8/2021 30 1/10/...
  • Anonymous's avatar
    Anonymous
    4 years ago

    klehar 

    Some transformations are required in power query, please download my sample pbix and check applied step in query editor.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.