Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
i have the following DAX as a starter for 10.
Table = ADDCOLUMNS( SUMMARIZECOLUMNS(PMS_PARTS[Product],PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND],PMS_FINANCIAL_PDS[Month Start]),"CountComplaints",[PMSComplaintsMN],"p-value",[p-value],"Trend",[__trend],"Significance",[Significance Y])
I want to show in the CountcComplaints column the overall sum in each row of data for the same Material_ID for period Y so for 722039672 as shown below (see image) i want to show 419 as opposed to 40, 36,43 and so on for each dat that relates to period Y,X and W (ps the sum for X and W - will be different as x is 24month and W is 36 months)
sample file here, you can create a new table in the sample file.
https://www.dropbox.com/s/jj62h2vxtepm5yd/Sample__Test%281%29.pbix?dl=0
I don't see the image. Can you post sample data as text and expected result? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Expected Result 419 for each data point which is the sum of the above.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |