Forum Discussion
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...
Hi @PradidMCP,
Uhmm I’m not in my laptop right now, but what if you expand that Filldown column, once expanded filter or replace using M code the desired column and once you finish and get what you need, select first columns (from year to Custom) go to transform, Group By and select All Rows as Operation and check if you get what you need.
Let me know if this helps.
Regards,
Gian Carlo Poggi
Uhmm I’m not in my laptop right now, but what if you expand that Filldown column, once expanded filter or replace using M code the desired column and once you finish and get what you need, select first columns (from year to Custom) go to transform, Group By and select All Rows as Operation and check if you get what you need.
Let me know if this helps.
Regards,
Gian Carlo Poggi