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] ) ) )
Hi,
I attached a sample file. I am having trouble replicating the solution you made.
I appreciate the help, let me know if you have trouble accessing anything.
Thank you!
https://drive.google.com/file/d/1gNgU38EX6l7EDIuCryQm9bVyBxobe-Z8/view?usp=sharing
Hi,
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=sharingThank you!