Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
Do you know the way to filter out the last 2 months (relative) in Power Query?
Solved! Go to Solution.
Eventually I did this with DAX:
Clients = CALCULATE(COUNTA('Outflow'[ID]);FILTER('Outflow;'Outflow'[Date]<DATE(YEAR(today());MONTH(today())-1;1)))
Eventually I did this with DAX:
Clients = CALCULATE(COUNTA('Outflow'[ID]);FILTER('Outflow;'Outflow'[Date]<DATE(YEAR(today());MONTH(today())-1;1)))
Hi @MarkShu,
>>Do you know the way to filter out the last 2 months (relative) in Power Query?
Normal filter not support this, I think you need to do some customize on fitler formula.
Add a filter on date column and use bold part to replace original date value:
#"Filtered Rows" = Table.SelectRows(#"Previous Steps", each [DATE] >= Date.AddMonths(List.Max(#"Previous Steps"[DATE]),-2))
Regards,
Xiaoxin Sheng
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |