Forum Discussion
Date filtering
Hi! I'm relatively new to Power Bi and was having trouble with implementing a date filter. The task is to have a date filter that only show data that falls before but NOT including the selct...
Hi,
Please check the attached file.
I changed a relationship type.
Name measure: = CALCULATE ( SELECTEDVALUE ( data[name] ), FILTER ( data, data[date] < MAX ( 'Calendar'[date] ) ) )
Jihwan_Kim
Super User
Super UserHi,
Please check the attached file.
I changed a relationship type.
Name measure: =
CALCULATE (
SELECTEDVALUE ( data[name] ),
FILTER ( data, data[date] < MAX ( 'Calendar'[date] ) )
)Hi,
I was wondering how I would alter this measure to exclude the people who leave (have a status of -1) but include everyone with a status of 1 and only show the people before but not including the selected date?
I attached a sample power bi file.
https://drive.google.com/file/d/1gyRlYRIZ0KckVOvFBFm6s2tGEq8MvpHM/view?usp=sharing
Thank you!