Filter for full months

[bilingual]

Hi , i  have a a query where i am importing data every monday, but for a lot of the visuals , they must only be updated when the month has ended and all data is available.

For example now i have a graph which shows data for September but only for the first 6 days.

I can off course remove September manually by filter , but is there a way to create a filter so only the full months  are shown?

[amitchandak · Accepted solution]

@bilingual , Not very clear.

You can have a column in the date table like

Month Type = Switch( True(),
Date[Date] = eomonth(Today(),0) && eomonth(Date([Date],0)= eomonth(Today(),0) ,"Current Month" , //Last Month
Date[Date] <> eomonth(Today(),0) && eomonth(Date([Date],0)= eomonth(Today(),-1) && ,"Current Month" , //This Month
[Month Year]
)

and Use current month as filter

[bilingual]

Hi Amit, unfortunately it does not work, as the Current Month is only active for one of the days in the month, not all days 😞

Current month = Switch( True();

Calendar[Date] = eomonth(Today();0) && eomonth(Calendar];0)= eomonth(Today();0) ;" Current month"

Calendar[Date] = eomonth(Today();0) && eomonth(Calendar];0)= eomonth(Today();-1) ;" Current month"

[Måned_år]

)

My example:

Date	Current month formula	Måned_år
28-09-2020	Current month	sep-20
21-09-2020	sep-20	sep-20
07-09-2020	sep-20	sep-20
08-09-2020	sep-20	sep-20
31-08-2020	sep-20	sep-20

[bilingual]

Thanks Amit,