March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello PBI community 🙂
My table has this view:
I want to see what is difference between VISIT_CREATE and VISIT_END.
For this task, I'm using DATEDIFF function, which really works:
Now, I want to see total average time difference for all visits in one visual, but, when I put my measure into card, PBI gives me wrong result.
In my table screen, visit_key 1 time difference is 24s, for 2 - 2,126s and average must be 1,075s, but my measure says it is 2,126s 😞
Have any idea how to solve this task?
Thanks in advance!
Solved! Go to Solution.
@odzelashvili1 , Try a measure like
AverageX(Values(MainTable[Visit ID]), [WD_create_to_end])
@odzelashvili1 , Try a measure like
AverageX(Values(MainTable[Visit ID]), [WD_create_to_end])
I have one very stupid question,
when I'm using code like this:
and then this:
it works, but it does not work when I'm using this code:
Can anyone tell me, what's wrong with second code?
thanks 🙂
I understand reason 🙂
thanks anyway
Thank you very much 🙂 it works!
Can you explane what really does this measure? I dont want to copy+paste, I want to understand how it works 🙂 Thanks again
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |