Forum Discussion

awillem's avatar
awillem
Frequent Visitor
8 years ago
Solved

Separating a Date Range

Hi! I'm VERY new to Power BI, but am finding the tutorials helpful.  What I have not found how to do, however, is to split a column with a date range into the beginning and ending dates.  I pulled my...
  • Anonymous's avatar
    Anonymous
    8 years ago

    awillem,

    Please check DAX in attached PBIX file. If you still have questions, please share sample data of your table.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

awillem,

Please check DAX in attached PBIX file. If you still have questions, please share sample data of your table.


Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

awillem  if you want an equivilent to LEFT and RIGHT, when you edit queries (Query Editor), there are functions called Text.Start and Text.End which will work identically to left and right.  Perhaps that will help?

 

If you are unsure how this would work.  Find your query (what will become your table).  Add a new step to create a Custom Column, found under the 'Add Column' area of the ribbon.  Here you can type your formula in with Text.Start and you can make use of the field picker on the right to help get the formatting correct.

 

Here are some links to the functions incase you need some more details:

 

https://msdn.microsoft.com/en-us/query-bi/m/text-start

https://msdn.microsoft.com/en-us/query-bi/m/text-end