1
Answer

Filtered rows for blank parameter

Mic Got

Mic Got
1y
535
1

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)
Next Recommended Forum