How to create static columns with dates in matrix table

[miodek]

Hi,

I have a martix table with users as rows, dates as columns and hours as values:

When I filter out by one user, the table only shows dates where hours occured (for that user):

I need all dates to be visible (after filtering out by one user), regaldress of the fact that hours did not occur on all the dates.

How do I do that? 

Thanks in advance!

[amitchandak · Accepted solution]

@miodek , add +0 to measure and try. Make sure you are using date/calendar table/dimension

sometimes we try this also

0 between range
new Measure = var _1= [Current Measure] +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1)

[miodek]

Hi amitchandak,

Works superb! Thanks very much.