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

 

and what I want to achieve is where 25 to be the day selected from my slicer.

 

 

if it helps to understand what I mean you can see also the MATRIX that holds this value

 

 

 

 

 

 

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...

     

1 Reply

  • 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...