Mic Got

Mic Got

  • 1.6k
  • 100
  • 7.9k

Filtered rows for blank parameter

Jul 10 2023 4:33 PM

Hi,

I have a report with 3 filter parameter.

These are FromDate, Todate, Article

The filter as follow is perfect if all parameter are populated with a value:

= Table.SelectRows(#"Modificato tipo", each [Data document] >= FROMDATE and [Data document] <= TODATE and [Articles] = ARTICLE)

The goal is to filter date with all articles if parameter article is empty.  

Thanks

 


Answers (1)