Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm new to DAX and PowerBi Desktop and am trying to something that is pretty easy in SQL but I'm strugging to replicate it in DAX.
I work for a school and I need to work out the number of students on roll based on start dates and leaving dates, below is some sample data.
StartDate | LeavingDate | Expected Result |
01/01/2018 | Yes | |
01/01/2018 | 01/01/2019 | No |
01/01/2018 | Yes | |
01/01/2018 | 01/01/2020 | Yes |
01/01/2018 | 01/01/2020 | Yes |
01/01/2018 | 01/01/2020 | Yes |
In SQL I would just do, SELECT * from Table WHERE (StartDate <= GETDATE() and (LeavingDate IS NULL or LeavingDate >= GETDATE()))
I managed to replicate the logic in excel using the formula below but I am struggling to replicate in in DAX/PowerBI Desktop.
=IF(OR(AND(A2<=TODAY(),B2>=TODAY()), AND(A2<=TODAY(),B2="")),"Yes","no")
Any help would be greatly appreciated.
Solved! Go to Solution.
Something like this as a calculated column maybe?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |