Forum Discussion
How to create static columns with dates in matrix table
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!
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)
2 Replies
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)Hi amitchandak,
Works superb! Thanks very much.
