Forum Discussion
NadaBen
9 years agoHelper I
dynamic filter
Hello, I import this table below from BI (Analysis services), this table is huge and i cannot import it entirely, in addition i need restrictred information from it, i want to filter my "snapshot...
Anonymous
9 years agoNot applicable
Hi NadaBen,
You can try to add dynamic date filter in power query:
PowerQuery Dynamic Date Dimension Table Filtering
Regards,
Xiaoxin Sheng
- NadaBen9 years agoHelper I
Hi Anonymous,
I read the article and followed the steps, but i don't seem to get the result. Actually, once i create (lastdate) and came back to the dable where i have the column table to do filter on it (date filter equals ), i got a error before changing "lastdate" in the M language.
What do you think is the problem?
- Anonymous9 years agoNot applicable
- NadaBen9 years agoHelper I
Here is a sample of my table, so what i need is to keep the last "Snapshot day", then 12 first weeks of "Common period Week"
https://drive.google.com/open?id=0BwbSVJQB7uVJMmxZQTJIWjQ4aUk
Thanks