Dax

[Kumarun]

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.....................

[v-yanjiang-msft · Accepted solution]

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.

[Kumarun]

Hai V-kalyj

Thank you so much.
In matrix visualization, I have row-wise country and column-wise dates.
But here need to display only current month's value only. not other months.
Once take values into the values section it's taking all the months.

I need to display the present month values only.

[v-yanjiang-msft]

Hi @Kumarun ,

According to your description, try to create a measure for the value, put the measure in the Values section.

Measure =
IF ( MONTH ( MAX ( 'Table'[Month] ) ) = MONTH ( TODAY () ), [Value], BLANK () )

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]

Column = IF([Date]>TODAY(),[Date],BLANK())
//Create new column 
//try this

[mh2587]

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

[Kumarun]

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

like this