Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I am attempting to add a column (titled 'active') that will be true/false data type based on if today's date is between the start and end date columns. For reference here are some data points below so I have been attempting DAX expressions to measure whether today's date is inbetween the two dates (result would equal true), or if today's date in NOT in between the two dates (result would equal false).
Solved! Go to Solution.
pls try
Active = IF('Table'[Start dar]<=TODAY() && 'Table'[End Date]>=TODAY(),TRUE,FALSE)
pls try
Active = IF('Table'[Start dar]<=TODAY() && 'Table'[End Date]>=TODAY(),TRUE,FALSE)
Thank you so much, that was it!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
98 | |
97 | |
38 | |
38 |
User | Count |
---|---|
153 | |
122 | |
76 | |
73 | |
66 |