Forum Discussion
Solved
excluding the Date Flagged
I would like to add logic to exclude days that have the "T" flag on the calendar in measure: "Value_measure_1" URL pbix: https://drive.google.com/file/d/1rTsECeGnNXDVG0TR-_tkpnNRZnQGRv9K/view?usp=...
yes you are right. update _Y variable as follows:
var _Y= DATESBETWEEN('Calendar'[Date], SELECTEDVALUE('Fact'[Data from]) , SELECTEDVALUE( 'Fact'[Data to]))* I've updated my previous response to correct a part of the measure based on feedback. this will make it easier for others to find the right answer quickly. thanks for feedback
Thank you, but unfortunately it doesn't work well. I took your variable into a separate measure and named the measure "_Tdates_X" .
Unfortunately, it wrongly counts the days that are supposed to have flag = "T"
PBIX: https://drive.google.com/file/d/1Zf_h6B2iYrYrfrnO9qJEmReXMk9cYPYb/view?usp=sharing
Selva-Salimi
Solution Sage
Solution Sage
yes you are right. update _Y variable as follows:
var _Y= DATESBETWEEN('Calendar'[Date], SELECTEDVALUE('Fact'[Data from]) , SELECTEDVALUE( 'Fact'[Data to]))
* I've updated my previous response to correct a part of the measure based on feedback. this will make it easier for others to find the right answer quickly. thanks for feedback