Forum Discussion

miodek's avatar
miodek
New Member
3 years ago
Solved

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): ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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)

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
miodek
New Member
3 years ago

Hi amitchandak,

 

Works superb! Thanks very much.