Forum Discussion
Solved
Pivot Table with Multiple Dates
Hello guys...hoping you can help me here. I want to create a pivot table where I can see at once the current number of man-days the worker has consumed. The workers are on-call, hence there are so m...
Creating PivotTable add data to data model
Add Name to Rows.
In PivotTable pane right click on table name and Add measure
add measures one by one
Finalize PivotTable with them
Depends on your Excel platform/version. Creating PivotTable you may add data to data model, add DAX measures like
Arrival:=MIN( daysConsumed[ARRIVAL DATE] )
Departure:=IF( "Active" IN VALUES(daysConsumed[STATUS]), BLANK(), MAX(daysConsumed[DEPARTURE DATE]) )
ManDays:=SUM( daysConsumed[MAN-DAYS] )
Current Status:=IF( "Active" IN VALUES(daysConsumed[STATUS]), "Active", "Inactive" )and use them creating PivotTable
Thanks Sergei.
This is the output I want to have.
But I don't know how to use your formula.I am using Excel 365.
Creating PivotTable add data to data model
Add Name to Rows.
In PivotTable pane right click on table name and Add measure
add measures one by one
Finalize PivotTable with them
- Thanks again. I'm almost there!
2 Things!
1. MIN of ARRIVAL does not show
2. There is a 3rd option on the STATUS. A Worker is ON LEAVE if he just termporarily left for R&R. I cannot add it in the formula because it says maximum of 3 arguments only.
Please help.
