Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Extract status on specific time

Hi all,   I have created a dummy-file to make it easier to understand and help with the question. The link to the file: https://www.dropbox.com/s/91dpxrh3umwuv12/Course%20dummy-file.pbix?dl=0   ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please refer to attached file with the solution

    Current Membership = 
CALCULATE (
    SELECTEDVALUE ( 'Members'[Membership] ),
    'Members'[From_date] <= MAX ( Course[Date] ), 
    'Members'[To_date] >= MAX ( Course[Date] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
Please refer to attached file with the solution

Current Membership = 
CALCULATE (
    SELECTEDVALUE ( 'Members'[Membership] ),
    'Members'[From_date] <= MAX ( Course[Date] ), 
    'Members'[To_date] >= MAX ( Course[Date] )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you so much tamerj1 ! 🙂