Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ending Percentage

I was wokring on this occupancy column its values are given in percent and i was trying to find the ending per for that column need help with the measure this was what i try but its not showing the right values. 

Target Occupancy = CALCULATE(MAX('Activity Budget'[Value]), FILTER('Activity Budget','Activity Budget'[Type] = "Target Occupancy"))
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Anonymous 

    Please try this measure. If this doenst work, share a dummy file with sample data

    Target Occupancy =
CALCULATE (
    LASTNONBLANKVALUE ( 'Activity Budget'[Date] , 'Activity Budget'[Value] ),
    'Activity Budget'[Type] = "Target Occupancy" )
)




3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Anonymous 

    Do you need the maximum value of the last value in the column, if you need the last value then you need to base on a column like date then you can use LASTNONBLANK function

    Can you try the following:

    Target Occupancy =
CALCULATE (
    MAX ( 'Activity Budget'[Value] ),
    'Activity Budget'[Type] = "Target Occupancy" )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      i needed the last percentage value for each activity buget [Date]

      • Fowmy's avatar
        Fowmy
        Super User
        4 years ago

        Anonymous 

        Please try this measure. If this doenst work, share a dummy file with sample data

        Target Occupancy =
CALCULATE (
    LASTNONBLANKVALUE ( 'Activity Budget'[Date] , 'Activity Budget'[Value] ),
    'Activity Budget'[Type] = "Target Occupancy" )
)