Forum Discussion

Kumarun's avatar
Kumarun
Helper 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
Super User
4 years ago

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

Kumarun's avatar
Kumarun
Helper I
4 years ago

this formula only checks true or false. But I need to display the dates from the present month up to  

like this