Forum Discussion

mterry's avatar
mterry
Helper V
9 years ago

Date format and table layouts

I have a few different tables I'm hoping to link up, but the layout is slightly different. On one of the tables, there is a column that includes the date of the transactions in YYYYMM format. In the ...
Need Help
mterry's avatar
mterry
Helper V
9 years ago
I didn't realize they used different languages. I'll attempt your suggestion in the power bi screen. If I make the change there, will it update the data table in the query screen as well?
Anonymous's avatar
Anonymous
Not applicable
9 years ago

No it wont.  Think of the "Edit Query" screen as a place to prepare the data prior to it being loaded DAX and having the "Manage Relationships" kick in.  There are often times where doing things in DAX or Power Query will give you the same result, so which ever one you choose is up to you.  If you need the changes to be inside your Edit Queries area, you would need to take the same Idea in that Dax expression and find the power Query equivilent.

 

I'm sure many of us can help with that.  I'll try, i just didn't have time prior to clicking 'Post' on this response.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Ok try this.  Go into Query Editor and select Custom Column.  You should get a pop up window that lets you name the column and has a box with "=" in it.  Place in

    Date.FromText(Text.Range([OLDDATE], 0, 4) & "-" & Text.Range([OLDDATE], 4, 2) & "-01")

    Then all you need to do is highlight [OldDate] and click on the correct fields from the field picker.  Just make sure you don't remove a comma by accident.