Forum Discussion

bilingual's avatar
bilingual
Helper V
5 years ago
Solved

Filter for full months

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 g...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
bilingual
Helper V
5 years ago

Thanks Amit,