Forum Discussion

vestergaardj's avatar
vestergaardj
Most Valuable Professional
10 years ago
Solved

Custom Column not showing

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

Need Help
  • Rémi's avatar
    Rémi
    10 years ago

    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.

     

     

1 Reply

  • Rémi's avatar
    Rémi
    Resolver III
    10 years ago

    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.