Forum Discussion

vestergaardj's avatar
vestergaardj
Icon for Most Valuable Professional rankMost 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 presen...
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.

     

     

Rémi's avatar
Rémi
Icon for Resolver III rankResolver 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.