Forum Discussion

Train23's avatar
Train23
Frequent Visitor
1 year ago

PBI Desktop Standard Deviation for Pivot Column

Hello I'm trying to create a measure in PBI Desktop for a Matrix Visual with a pivot column.  I need to create a Standard Deviation for each row of total demand.  See example data below, month-year is pivot column in power query.

Row 1 " Total Demand" = 94 - need StDev for 94

Row 2 - Total Demand" = 3     need StDev for 3

etc, etc.

 

 

Need Help

2 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    1 year ago

      Train23

    • STDEV.S
    • STDEV.P
    • STDEVX.P
    • STDEVX.S

      The above functions in dax can perform standard deviation, have you tried using them. I am attaching a video for your reference:

      https://www.youtube.com/watch?v=A4oJNgB6Pnk

       

      Please follow the steps and you should be able to write the formula 

       

       

       

      Need a Power BI Consultation? Hire me on Upwork

       

       

       

      Connect on LinkedIn

       

       

       








      Did I answer your question? Mark my post as a solution!
      If I helped you, click on the Thumbs Up to give Kudos.

      Proud to be a Super User!
       

       

     

    • Train23's avatar
      Train23
      Frequent Visitor
      1 year ago

      Hello thank you for the suggestions,  Yes I have tried all the combinations and the results are either NaN or the Standard Deviation calculates the whole table NOT rows.

      I'm trying to get the Standard Deviation for 12 month total for each part number.