Custom Column not showing

[vestergaardj]

Hi

I have described the issue in the following blog post: http://t-sql.dk/?p=1269

Basically it's when I add a custom column, containing a formular, the column does not appear to be present in the data source view in Power BI Desktop Designer

Brgds

Jens

[Rémi · Accepted solution]

Hi,

I don't know why your column doesn't appair, but can you try DAX fonctions to do that.

Into your data, once the request is loaded, you can add calculated columns (like this month column) and it's more suitable to do here.

Choose the button "Add calculated column" on the table, then type that :

Month = FORMAT([Date];"mmm")

The order of months may be wrong, then you have to add another column :

sortMonth = MONTH([Date])

Sort your first column by sortMonth column and it's done.