Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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 and two prior is -2. My report typically would have 2 fiscal years except for a period of 3 weeks at the beginning of a new fiscal year where there would be 3 fiscal years. Currently when I load the Dim table, I filter out the second fiscal year. In the advanced editor, it looks like this:


#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([RLTV_FISC_YR_NR] <> -2)),


I am wondering if there is a straight forward way to stick an if statement in there? For example, if today's month is November AND todays day is less than or equal to 15 then load all 3 years else do not load relative year -2.


I can think of a round about way of creating a table to determine which years to load and then joining the tables to get a single table. I just didn't want to create this kind of work around if there was a straight forward way of doing it in the Advnaced Editor.


Thanks in Advanced. I'm just getting started with M.




You can use IF condition in Advanced Editor.


I assume your table looks like below.




You can use code below in Advanced Editor to get the records you mentioned.



    Source = Table.SelectRows(#"yearInfo", 

             if Date.Month(DateTime.LocalNow()) = 11 and Date.Day(DateTime.LocalNow()) <= 15 then #"yearInfo" else each([relative year] <> -2))




This is the result:




To know more details about the usage of power query, please take a look at


Best Regards



Impactful Individual
Impactful Individual

Yes, but it's probably easier to get it started by using the Create Custom column dialogue and then cleaning it up in Advanced Editor:

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors