Forum Discussion

iioannou's avatar
iioannou
Helper I
8 years ago
Solved

Filtering and DAX question

Hello,     I have a very simple question and I need some help. I have this custom column   Occupancy % TMY = (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 'Almyra Rooms'[Capacity]) / 25   ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago
    Occupancy % TMY = var DateDiff = DATEDIFF(
                                     CALCULATE(MIN('Date'[Date]);ALLSELECTED('Date'[Date]));
                                     CALCULATE(MAX('Date'[Date]);ALLSELECTED('Date'[Date]));
                                     DAY)
                  return (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 
                               'Almyra Rooms'[Capacity]) / DateDiff)



    But it will work as measure only, not as calculated column...

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Occupancy % TMY = var DateDiff = DATEDIFF(
                                 CALCULATE(MIN('Date'[Date]);ALLSELECTED('Date'[Date]));
                                 CALCULATE(MAX('Date'[Date]);ALLSELECTED('Date'[Date]));
                                 DAY)
                  return (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 
                           'Almyra Rooms'[Capacity]) / DateDiff)



But it will work as measure only, not as calculated column...