Forum Discussion

atasgao's avatar
atasgao
Icon for Helper II rankHelper II
4 years ago
Solved

Dynamic Title with month name and year

Hello,    So, I want to create a title with a condition where if the current date >= 15 of the month then show last month(ie Nov) else show the last to last month (October) and the year 2021.  ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    atasgao 

    you can try this

    Measure = 
VAR last=EDATE(today(),-1)
VAR last2=EDATE(today(),-2)
RETURN if(day(today())>=15,FORMAT(last,"mmmm")&" "&year(last),FORMAT(last2,"mmmm")&" "&year(last2))
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

atasgao 

here is a workaround for you

Measure = 
VAR enddate=month(eomonth(today(),-2))
return if(max('Table'[Month])=enddate,1,0)

add this measure to visual filter and set value is 1

atasgao's avatar
atasgao
Icon for Helper II rankHelper II
4 years ago

ryan_mayu  Sorry, But I want to show the data  from Jan to Nov and after 15 business day I want to show the data from Jan to dec

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    atasgao 

    i don't have your full data, so I assume you can get the business day.

    just update the previous measure and add the workday condition in IF function

    Measure = 
VAR enddate=month(eomonth(today(),-2))
return if(max('Table'[Month])<=enddate,1,0)