topic Re: custom column for DirectQuery report in DAX Commands and Tips

custom column for DirectQuery report

Anonymous — Thu, 16 Apr 2020 13:03:55 GMT

Hello, I created report using import data option and made this custom column. This column works in import version of report but now I need to create it in the DirectQuery version of the report and when I try to use same formula I get message that SUM function is not supported in DirectQuery model. Is there a way to create column that would produce same results. For the record this column is being used in slicer visual to filter table that has conditional formating. Thank you.

Re: custom column for DirectQuery report

Greg_Deckler — Thu, 16 Apr 2020 13:24:34 GMT

You cannot create columns in Direct Query reports, you can only create measures.

Re: custom column for DirectQuery report

Anonymous — Thu, 16 Apr 2020 13:28:48 GMT

I created new columns for other functions using switch DAX function or date diff functions and didnt get any problems.

Re: custom column for DirectQuery report

Anonymous — Mon, 20 Apr 2020 08:32:53 GMT

Anyone know how this function can be used in Measure to archieve slicer capabilities or modified so it would still be available to with slicer visual?

Re: custom column for DirectQuery report

Anonymous — Mon, 20 Apr 2020 13:37:32 GMT

Could anyone close this topic I reposted more detail one in forum section that is more appropriate to the problem I have.