Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I am trying to get date difference with allexcept
Can you provide some sample data and expected output you hope to get?
The first variable in CALCULATE() should be an expression which returns a single value while FILTER() will return a table.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Nidhi_Kochrekar , New column
Seconds to open = CALCULATE(DATEDIFF(Append1[Submit Date],Append1[Last Modified Date],SECOND), ALLEXCEPT(Append1,Append1[ID]))
new table
Seconds to open = CALCULATE(AverageX(Append1, DATEDIFF(Append1[Submit Date],Append1[Last Modified Date],SECOND)), ALLEXCEPT(Append1,Append1[ID]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |