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])
     
     

5 Replies

    • 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])