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"
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |