Forum Discussion
Date format and table layouts
Are you adding this custom column in through the "Query Editor" or through the Data screen as part of Power BI? The formula's i've shown there are DAX formulas, not Power Query formulas. There should be a Power Query equivelent if you wish to do it there.
Sorry for the late reply, I was sent out of the country for a while. To answer your question, I was adding the column through the Query Editor. I'm not familiar with adding the column through the Data screen. I guess I assumed DAX could be used through the Query Editor, but apparently not?
DAX is the language used in the main Power BI desktop screens. A completely different language is used called Power Query (also referred to as M).
- 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?
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.