Forum Discussion

Kumarun's avatar
Kumarun
Icon for Helper I rankHelper I
4 years ago
Solved

Dax

Need to display dates from the present month and year up to what are the dates we have. without slicer.   Ex: Present month is June so, June 2022, July 2022.....................
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Kumarun ,

    According to your description, here's my solution, create a measure.

    Check =
IF ( MAX ( 'Table'[Month] ) > EOMONTH ( TODAY (), -1 ), 1 )

    Put it in the visual filter and select its value to 1, 

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

Just define the condition in dax like below
   = date >= TODAY()