Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with a measure.

Hi   I have a measure for Occupancy per course as follows   Occupancy Forecast (%) = DIVIDE( SUMX('CTS Forecast Course Volume', [Forecast Total Attendees]), SUMX('CTS Forecast Course Volume', ...
measure
Year to date
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Not clear.

    Is this not working

    YTD Occupancy Forecast (%)= CALCULATE([Occupancy Forecast (%)],DATESYTD('DateMASTER'[Date],"31/03"))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Not clear.

Is this not working

YTD Occupancy Forecast (%)= CALCULATE([Occupancy Forecast (%)],DATESYTD('DateMASTER'[Date],"31/03"))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Amit....for some odd reason i didnt consider it, was over complicating it in my brain