topic Re: Display all months but filter on date in DAX Commands and Tips

Display all months but filter on date

Anonymous — Mon, 06 Apr 2020 16:57:46 GMT

I would like to know if it is possible to display all months for a graph but select a date in a slicer.

Like I want the full month value for January and February and month to date for March

Is it possible to create a measure to acheive this?

Thanks

Re: Display all months but filter on date

Greg_Deckler — Mon, 06 Apr 2020 17:19:13 GMT

Yes, you would need an ALL statement in there and then filter down to what you need. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Re: Display all months but filter on date

Anonymous — Mon, 06 Apr 2020 18:41:23 GMT

Thanks

But it seems like this measure does not behave like I want

Measure = VAR _MAXYEAR = MAX( 'Date'[Year] ) VAR _TMPTABLE = CALCULATETABLE( 'Date'; ALL( 'Date'[Year] ); ALL( 'Date'[Month] ); ALL( 'Date'[Date] ) ) RETURN SUMX(FILTER(_TMPTABLE; 'Date'[Year] <= _MAXYEAR);[Turnover Tax Excl EUR])

I tried to have all possible dates I could, but as a result, in my graph the only date displayed is 2020-03-16