Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good afternoon all,
I have the following measure to return the latest task/appointment date, which works brilliantly.
Based of this measure, I now also need to return Task[task_record_type]. Any ideas how I might do this? Would a second measure be best, or modify this measure?
https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=sharing
Thanks so much,
Solved! Go to Solution.
PBI file attached. Those images are very small so i can barely read anything.
@amitchandak Thanks for your time with this. I think you are close, however I neglected to mention there is Task[task_record_type] and also Appointment[Record Type] to consider.
Hope that makes sense.
I have shared on my google drive.
https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=sharing
Thanks!!
There's a lot of data there which in turn is causing confusion. Could you share a smaller dataset and show the expected result.
@Ashish_Mathur Thanks for your reply. I have updated the data set and included expect result as requested. Hope this helps!
https://drive.google.com/file/d/1poBCfP3UPDIl7tDuTjHdfsBuyqT2cEwA/view?usp=drive_link
You are welcome. Thank you for your kind words.
@Auski , Try like
CALCULATE (
Lastnonblankvalue ( Task[Created_Date], max(Task[task_record_type] )),
FILTER ( Task, Task[Created_Date] < TODAY () ),
Task[task_record_type] <> "System Generated Task"
)
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |