Last answered:

30 Mar 2020

Posted on:

26 Mar 2020

0

Calculate Standard Deviation with filters in Power BI

Hello team, I would like to calculate the Standard Deviation but without including 2 days (Saturdays and Sundays), but the result is the same with or without the filter. I calculate it on excel and it should be larger than in Power BI This is the formula i am using: StandardDeviation = CALCULATE(STDEV.S('General Tickets'[Request Date]), FILTER('General Tickets', 'General Tickets'[Day Number] <> 6 || 7))   But i am not sure why it doesn't apply my filters.
Thanks
1 answers ( 0 marked as helpful)
Instructor
Posted on:

30 Mar 2020

0

Submit an answer