Forum Discussion
Can you do if statements in Advanced Editor in Power Query?
Hi Everyone, I am loading a Fiscal Reference Date Dim that has 3 years in it, the current year and 2 prior years. There is a column for relative year where the current year is 0, one prior is -1 ...
tjd
Impactful Individual
Impactful IndividualYes, but it's probably easier to get it started by using the Create Custom column dialogue and then cleaning it up in Advanced Editor: https://social.technet.microsoft.com/Forums/en-US/c94378ec-98ac-42c6-8a92-5f247b9e3b25/if-function-in-power-query?forum=powerquery