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
Lokesh VarmanPosted Jul 10, 2023, 5:06 PM
To filter the date with all articles if the Article parameter is empty, you can modify your filter expression as follows:
= if ARTICLE = null or ARTICLE = "" then
Table.SelectRows(#"Modificato tipo", each [Data document] >= FROMDATE and [Data document] <= TODATE)
else
Table.SelectRows(#"Modificato tipo", each [Data document] >= FROMDATE and [Data document] <= TODATE and [Articles] = ARTICLE)