Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating Min date and Max date from multiple date columns for each row in Power query.

Finding Min(Start) date and Max(End) for below sample data- For each Row. Some of the dates will be blank as well   NPI Program P/n count est Mfg Facility Location Launch GW1  GW2 GW3 PD1...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    Try these calculations in new custom columns:

     

    // Start Date
List.Min({[Launch], [GW1], [GW2], [GW3]... })

// End Date
List.Max({[Launch], [GW1], [GW2], [GW3]... })

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

Try these calculations in new custom columns:

 

// Start Date
List.Min({[Launch], [GW1], [GW2], [GW3]... })

// End Date
List.Max({[Launch], [GW1], [GW2], [GW3]... })

 

Pete

  • Shivam_Kathpal's avatar
    Shivam_Kathpal
    Frequent Visitor
    2 years ago

    Hi BA_Pete 

    Thanks for the solution, I also kudoed your post and I tired the mquery and its working good, but since we have data as direct query from sql, so we cannot use calculated column function in direct query, can you suggest some dax also to get the same solution by using measure or dax.
    Thanks,

    • BA_Pete's avatar
      BA_Pete
      Super User
      2 years ago

      Hi Shivam_Kathpal ,

       

      I'd recommend opening a new topic on the Desktop forum.

      Direct Query can be a bit tricky for writing some more advanced measures, and DAX isn't really my strong point to be honest.

       

      Pete