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 i...
Need Help
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.