Forum Discussion
Remove previous months while keeping items with no data
I would like to remove the following circled months from this bar visualization, but keep the bars post October 2022 and any future months with no data. I have selected "Show items with no dat...
Ahmedx
Super User
Super Useryou need to read the earliest date and set the condition as follows
VAR _MinDate = CALCULATE(MIN('Calendar'[Date]), FILTER(ALL('tablesales'), [your mesure]> 0)
VAR Result = IF ( MAX('Calendar'[Date])>=_MinDate , [your mesure])
RETURN
Result