Neel98Frequent Visitor3 years agoSolvedDAX: Pivot column Hi, I need to create the pivoted column in Dax. Here I have attached the sample data. My dataset has a Number, date and value column. The final output will be Number and two date fields. Is this pos...Show Moretamerj1 to Neel983 years agoNeel98 Please try NewTable =ADDCOLUMNS (VALUES ( 'Table'[Number] ),"5-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 5 ) ),"29-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 29 ) ))
tamerj1 to Neel983 years agoNeel98 Please try NewTable =ADDCOLUMNS (VALUES ( 'Table'[Number] ),"5-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 5 ) ),"29-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 29 ) ))
tamerj1 to Neel983 years agoNeel98 Please try NewTable =ADDCOLUMNS (VALUES ( 'Table'[Number] ),"5-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 5 ) ),"29-Sep", CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Date] = DATE ( 2022, 9, 29 ) ))
tamerj1Community Champion3 years agoNeel98 A matrix visual will do or you're looking for a calculated table?
Related contentIssue with pivoting via DAXPivot issuePower BI Pivot Columns ?Pivot / Unpivot?Power Query Pivoting columns issue
