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 data from Excel, and in Excel I would normally use a left/right text function. Not sure how to do this in Power BI.  Any help would be great. Thanks!

3 Replies

    • 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

    • awillem's avatar
      awillem
      Frequent Visitor
      8 years ago

      Thank you.  I figured this out.