Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello colleagues,
I have these 2 tables:
2021 Cases - unique records (clients)
2021 Online Q - each client has multiple rows, one per topic, with a status (responsecasestatus) and a date.
I want to create a calculated column on the 2021 Cases that would bring me the Last Modified date for that client, once there are no rows-Topic on status "Waiting for Corrections". It's crucial that all records for that client have other status.
The Last Modified date can be different for the same client, as it varies by Topic. I would want to flag the most recent one.
The 2021 Online Q table looks like this:
So we have different topics for each participant ID, each topic can have the status:
Waiting for Corrections
Waiting for Review
Review in Progress
I want to bring a calculated column on the clients table, with the last modified date per client id, only once I have no other rows on Waiting for Corrections.
So for example client ALB378273 will show blank as we still have one topic waiting for corrections, but client ARE379242 is all good to go and will need to show the latest date which is March 12th.
Hope this explained a little bit more what I need to do and that you can show me some light here
Regards,
Agustina
Solved! Go to Solution.
Hey @Agustina ,
try the following measure:
LastDate =
IF(
CALCULATE(
COUNTROWS( '2021 Online Q' ),
'2021 Online Q'[ResponseCaseStatus] = "Waiting for Corrections"
) > 0,
BLANK(),
CALCULATE( MAX( '2021 Online Q'[LastModified] ) )
)
Hello @Agustina ,
I didn't understand the issue with the "status 'Waiting for Corrections'". Maybe you can explain that again?
Except for that you can add a new calculated column to the table '2021 Cases':
LastDate = CALCULATE( MAX( '2021 Online Q'[LastModified] ) )
Hi @selimovd I've just updated the original post with more information to explain it better 🙂 thank you!
Hey @Agustina ,
try the following measure:
LastDate =
IF(
CALCULATE(
COUNTROWS( '2021 Online Q' ),
'2021 Online Q'[ResponseCaseStatus] = "Waiting for Corrections"
) > 0,
BLANK(),
CALCULATE( MAX( '2021 Online Q'[LastModified] ) )
)
User | Count |
---|---|
92 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |