Forum Discussion
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.....................
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Just define the condition in dax like below
= date >= TODAY()this formula only checks true or false. But I need to display the dates from the present month up to
like this
Column = IF([Date]>TODAY(),[Date],BLANK()) //Create new column //try thisHi 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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
