Forum Discussion
Solved
Functions in add Custom Column to Query (M coding)
Hi folks. I'm experimenting with using queries to filter other queries so that I don't have to use the code of some queries multiple times. However, I'm having trouble coding the columns in M. So...
Oh. I realized that using DAX code in M code probably doesn't work. This works:
Include_F = if [#"TABLEA.TRAINEE"] is null and [#"TableA.TRAINER"] is null then false else true
Now let's see how this affects load times, and if we can make it work for Table C.
Oh. I realized that using DAX code in M code probably doesn't work. This works:
Include_F = if [#"TABLEA.TRAINEE"] is null and [#"TableA.TRAINER"] is null then false else true
Now let's see how this affects load times, and if we can make it work for Table C.