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.
ALLEXCEPT – DAX Guide
CALCULATE - DAX Guide
DATEDIFF - DAX Guide
Best Regards, Community Support Team _ JingIf 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]))
Seconds to open = CALCULATE(AverageX(Append1, DATEDIFF(Append1[Submit Date],Append1[Last Modified Date],SECOND)), ALLEXCEPT(Append1,Append1[ID]))
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!