Forum Discussion

BillyT_350's avatar
BillyT_350
Helper V
7 years ago
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...
Need Help
  • BillyT_350's avatar
    BillyT_350
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi BillyT_350 

 

IF is not IF in Power query, it is  "if"

 

Example 

Excel =IF(test, value_if_true, value_if_false)
Power Query =if test then value_if_true else value_if_false

 

Also you could download the

Power Query Formula Language Specification  (October 2016).pdf from dwonload.microsoft.com for handy reference.

 

Cheers

 

CheenuSing