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.
So I have these two columns that are formatted as date / time.
When I use the datediff formule, it works for day and hour, but when I change to minute or second I get this message.
I am connecting via directquery.
Does anybody know are way i can get this information?
Hi @Darwell
Thanks for the reply from @lbendlin .
The error is saying that it is unable to convert a DAX query to a query against a data source. There are several possible reasons for this:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
subtract the two values, multiply the result by 1440 or 86400
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |