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
Thanks
1 answers ( 0 marked as helpful)
Hi, Miguel,
Please take a look here: https://community.powerbi.com/t5/Desktop/Standard-Deviation/td-p/66609 :)