Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic title Question

How do you make the title card dynamic where  insteading of stating  "Last Month" it would say last 28 days (For Feb) in March but this would change to last 31 days in 2 weeks time (for March) in Apr...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Assume the month selection is coming from a date table or today

     

    Measure  =

    var _max = day( eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0))

    return

    "Last " & _max & " Days"

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hello Anonymous ,
This can be accomplished by extracting the last day of the selected month
Using the following function combination:
test = day(EOMONTH(MAX('Table'[Date]),0))
Here is a picture for your convenience, as well as a link to a sample file.
https://drive.google.com/file/d/1Yl96_tsBjz6kWNMjDcmbjdCuCDavSaRU/view?usp=sharing 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!