Forum Discussion

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago
Solved

Use Calendar for Time Intelligence on another Table with Multiple Dates

What do you think the optimal way to plot muliple dates from the same table would be in a combo column-line chart?   I have work units that have a 'Created' date and a 'Closed' date. I want to impl...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    gemcityzach Yeah, doesn't work that way other than perhaps overlaying two visuals but that's a mess. Better to create a measure for the closed count of ids like this:

    Closed Count Measure = 
  VAR __Date = MAX('Date'[Date])
  VAR __Table = FILTER( ALL('Table'), [Closed Date] = __Date )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

gemcityzach That's typically done in your formatting for the column.

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago

Yeah I checked for that but it doesn't offer the ability to 'group' the data into months. There are just variations on MM-DD-YYYY. I used the SQIBI calendar template (DAX Date Template - SQLBI).