Forum Discussion
Standard Deviation on items sold
Hello, I want to calculate the Standard Deviation for a specific product For that, I have a sales table from the last 180 days with daily granularity (Date, product, vendor, items sold) If...
I want to take in consideration days without sales !!
Shaurya
Memorable Member
Memorable MemberHi Anonymous,
You can use the FILTER function to avoid days without any sales from your calculations.
Example:
Measure = CALCULATE([Your Measure],FILTER('Table','Table'[Sales]=0))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
I want to take in consideration days without sales !!