Forum Discussion

PradipMCT's avatar
PradipMCT
Resolver II
6 years ago

Write IF function with in Table Rows

Hi Friends,   Thanks for your help.    I am working on a table as shown in the screenshot. I want to write IF function in the table rows. So far i have written the functions like, Table.Skip, Tab...
Need Help
Show and Tell
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi PradipMCT ,

 

Please see picture below. To add an if column, go to Add Column, select Condition Column, and fill in the boxes.  You may add additional if statements.  If you look at the function bar after you have done this, you will see the M language terminology for this.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

  • PradipMCT's avatar
    PradipMCT
    Resolver II
    6 years ago

    Hi Nathaniel_C 

     

    Thanks a ton for responding. 

     

    I know this way to write IF Function. My question was how to write IF function in the Row Table as shown/highlighted below in the screenshot. In those Row Tables, I would like to write IF function that is applicable to all the rows not just the current table. These tables are hidden inside the row. Hope i could make it simpler to understand!

     

    Pradip Pardeshi

    Microsoft Certified Trainer

    Pradip's Youtube Channel

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      6 years ago

      Hi PradipMCT ,

      I have heard that ImkeF is the one to go to for M language questions!

      Nathaniel