Forum Discussion

Helper V

4 years ago

Solved

Conditional Filter

Hello, I have a structured table in Excel recording sales, and naturally I have a column date I have another table called DateMin I have another table called DateMax I have three queries in...

BA_Pete
4 years ago
Ah, yes, that makes sense. My bad.

This is always going to be a cyclic reference as you're applying this as a step in your fact table.

Revert your DateMin/Max queries back to how they were originally, then try this as your final fact table step:

Table.SelectRows( #"Personnalisee ajoutee", each [Date] >= (DateMin ?? #date(1900,01,01)) and [Date] <= (DateMax ?? #date(2999,12,31)) )

Pete

BA_Pete

Super User

4 years ago

Ah, yes, that makes sense. My bad.

This is always going to be a cyclic reference as you're applying this as a step in your fact table.

Revert your DateMin/Max queries back to how they were originally, then try this as your final fact table step:

Table.SelectRows(
    #"Personnalisee ajoutee",
    each [Date] >= (DateMin ?? #date(1900,01,01))
        and [Date] <= (DateMax ?? #date(2999,12,31))
)

Pete

Einomi

Helper V

4 years ago

Works Perfect 😁

Many thanks

PS : if you have a few min to send me links about the ?? or to explain it to me you are more than welcome

always want to learn and share

BA_Pete
Super User
4 years ago

In Power Query, ?? is the coalesce operator i.e. it converts null values to a chosen value.

In the case of (X ?? Y) this translates to "if X is null then Y".

Pete