Forum Discussion
How do I visualize only data which is never than yesterday?
Hi Newbie here. I don't if it's smartest to do this in the web version or desktop. So I put my question here... I have an Excel sheet, which contains a date field, and I only want to show the...
Hi jgni,
I'd like to suggest you add a filter at query editor side ("today" as the parameter).
For example:
FilterRows = Table.SelectRows(#"Name of Previous Step", each [Date] >= DateTime.LocalNow())
Reference link:
Power Query Current Date Filter
Regards,
Xioaxin Sheng
I'm still a newbie in PBI.
How do I add a filter?
In Excel or Power BI - Query Editor? And if the latter, then how?
Regarfs
Jan