Forum Discussion
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 ...
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).