Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello ! i'm beginner in power BI and i would like to create table with basic measures to use it as filter for graphics, like take only data from the 4 last weeks, month by month or since a year is it possible and if not how can i do that thanks. (sorry for my english it's not my main tongue )
Solved! Go to Solution.
Hi @Stuk,
It is hard to use measure to filter table, you can dax to write a calculate table which used to filter the last 4 weeks. Then use the new table as the datasource of the visual .
Sample:
Table =
var temp= LASTDATE(VALUES(Sheet1[Date]))
Return
FILTER(Sheet1,[Date]>=DATE(YEAR(temp),MONTH(temp)-1,DAY(temp)))
Regards,
Xiaoxin sheng
Hi @Stuk,
It is hard to use measure to filter table, you can dax to write a calculate table which used to filter the last 4 weeks. Then use the new table as the datasource of the visual .
Sample:
Table =
var temp= LASTDATE(VALUES(Sheet1[Date]))
Return
FILTER(Sheet1,[Date]>=DATE(YEAR(temp),MONTH(temp)-1,DAY(temp)))
Regards,
Xiaoxin sheng
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |