DAX: Pivot column

[Neel98]

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 possible in DAX?

[Neel98]

Thank you. I am looking for a calculated table. 

[tamerj1 · Accepted solution]

@Neel98 

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]

@Neel98 

A matrix visual will do or you're looking for a calculated table?