Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Normal Distribution Curve

Hi,

 

I created normal distribution curve from Joseph Romero videos but the values don't change if I try to change the date.

Below are the formulas I used.

 

Please let me know how I can filter with date values

 

f(x) =
 EXP((VALUES('Normal Distribution'[X])-[Mean new])^2/(2*[STDEV new]^2)*-1)/(SQRT(2*PI())*[STDEV new])
Normal Distribution =
VAR MinValue = Floor([-2 sigma new],1)
VAR MaxValue = CEILING([+2 sigma new],1)
RETURN
SELECTCOLUMNS(CALENDAR(MinValue,MaxValue),"X",INT([Date]))
Z = ('Normal Distribution'[X]-[Mean new]/[STDEV new])
Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler  Here's the sample data. I used this table to calculate mean and standard deviation.

      I want to use run time dates to filter the normal distribution curve.

      • v-xicai's avatar
        v-xicai
        Community Support
        5 years ago

        Hi Anonymous ,

         

        You may use measure instead of calculated column to create the formula. You couldn't have a calculated column interact with a slicer since columns are only calculated at data load/refresh. 

         

        Best Regards,

        Amy 

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xicai's avatar
    v-xicai
    Community Support
    5 years ago

    Hi  Anonymous  ,

     

    Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy