Forum Discussion

Yash_Kumar_CDA's avatar
Yash_Kumar_CDA
New Member
2 years ago

Dynamic Column Name Based on Date

Hi Team

I Need to have Dynamic column Name for Selected month 

i.e. I have created till the point with the use of parameter where using today

when the data is static 

I want that the title also changes when I select the different Month

 

Thanks In Advance

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Yash_Kumar_CDA , Column can not refer values in slicer and filter, the best you can hve like

     

    Month Type = Switch( True(),
    eomonth([Date],0) = eomonth(Today(),-1*month(Today())),"Last year Last Month" ,
    eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
    eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
    Format([Date],"MMM-YYYY")
    )

     

     

    Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
    ,'Date'[Date]=TODAY()-1,"Yesterday"
    ,'Date'[Date]=TODAY()-2,"Day before Yesterday"
    ,'Date'[Date]&"")

     

    and default the slicer based on that Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA