The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Calculate Standard Deviation with filters in Power BI

Calculate Standard Deviation with filters in Power BI

Super Learner
0
Votes
1
Answer

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 Answer

365 Team
0
Votes