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.
Can someone help me in converting the sql where condition into dax
I wasn't sure , how to add the subquery part in dax
Solved! Go to Solution.
@GMkk , Try using filter formula
FILTER (
'YourTableName',
'YourTableName'[Status] = "Active" &&
( ISBLANK ( 'YourTableName'[END_DATE] ) || 'YourTableName'[END_DATE] >= TODAY () ) &&
'YourTableName'[START_DATE] <= TODAY () &&
(
ISBLANK ( 'YourTableName'[CONTRACT_ID] ) ||
NOT (
'YourTableName'[CONTRACT_ID] IN
FILTER (
'YourTableName',
'YourTableName'[EMPLOYEE_STATUS] = "Active" &&
( ISBLANK ( 'YourTableName'[END_DATE] ) || 'YourTableName'[END_DATE] >= TODAY () ) &&
'YourTableName'[START_DATE] <= TODAY () &&
NOT ISBLANK ( 'YourTableName'[TEMPCONTRACT_ID] )
)
)
)
)
Please accept as solution and give kudos if it helps
Proud to be a Super User!
Ignore SQL and embrace DAX.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
@GMkk , Try using filter formula
FILTER (
'YourTableName',
'YourTableName'[Status] = "Active" &&
( ISBLANK ( 'YourTableName'[END_DATE] ) || 'YourTableName'[END_DATE] >= TODAY () ) &&
'YourTableName'[START_DATE] <= TODAY () &&
(
ISBLANK ( 'YourTableName'[CONTRACT_ID] ) ||
NOT (
'YourTableName'[CONTRACT_ID] IN
FILTER (
'YourTableName',
'YourTableName'[EMPLOYEE_STATUS] = "Active" &&
( ISBLANK ( 'YourTableName'[END_DATE] ) || 'YourTableName'[END_DATE] >= TODAY () ) &&
'YourTableName'[START_DATE] <= TODAY () &&
NOT ISBLANK ( 'YourTableName'[TEMPCONTRACT_ID] )
)
)
)
)
Please accept as solution and give kudos if it helps
Proud to be a Super User!
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
71 | |
49 | |
45 | |
20 | |
17 |