Forum Discussion
2 columns of dates. Pivot occassions per month
I have 2 columns of dates of tasks performed. I need to create a chart preferably pivot to show occurances per month of each. Would I need a 3rd column as it currently just used the first for the X-...
If you are on Windows you may do that with data model. Be sure grouping is enabled in options
Creating PivotTable add data to data model.
Next depends on your business logic. You may use dates grouped in table. Better to create in Power Pivot calendar table, create relationships
measures
#A:=CALCULATE( COUNTROWS(Table1), USERELATIONSHIP(Table1[DateA], 'Calendar'[Date] ))
#B:=CALCULATE( COUNTROWS(Table1), USERELATIONSHIP(Table1[DateB], 'Calendar'[Date] ))and create PivotTable/Chart from data model
