basic measures for graphics?

[Stuk]

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 )

[v-shex-msft · Accepted 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