Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Format

Hi, I need to implement this table onto Power BI     The table that I currently have right now is:   Would appreciate any kind of help from you guys. Thank you!
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Anonymous 

    you can create two measures

    startdate = min('Table'[start date])
    enddate = max('Table'[end date])
     
     
ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

Anonymous 

maybe you can try group by in PQ

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    appreciate ur help. however, i think it has to be done using a measure. using the PQ will remove my other data found in the query.

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      3 years ago

      Anonymous 

      you can create two measures

      startdate = min('Table'[start date])
      enddate = max('Table'[end date])
       
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thanks for the help!