1 messure 2 Date Hirarcies in Clustered Chart

[Anonymous]

I have a column (Incident), and I created a messure Count(Count_of_Incidents), same table has 2 dates columns Create_Date and Resolved_Date.

I created Hirarchy on both Date Columns (Yr--> QTR --> Mo).

I want to create a Clusterd column chart, that shows Count_of_Incidents by Create_Date and Count_of_Incidents by Resolved_Date

I shared AXIS with both Hirarchies, but it does not show the data for Resolved_Date.

Apprecitae your help.

[v-chuncz-msft]

@Anonymous,

You may add a calendar table and use measures below.

Measure =
VAR minDate =
    MIN ( 'Calendar'[Date] )
VAR maxDate =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        COUNT ( Table1[incident] ),
        Table1[Create_Date] >= minDate
            && Table1[Create_Date]
            < maxDate + 1
    )

Measure 2 =
VAR minDate =
    MIN ( 'Calendar'[Date] )
VAR maxDate =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        COUNT ( Table1[incident] ),
        Table1[Resolved_Date] >= minDate
            && Table1[Resolved_Date]
            < maxDate + 1
    )

[Anonymous]

Sorry, I'm new to Power BI. When you say Add Calender Table. Is it an option within Power BI or do I have to create a table in the DB?

[v-chuncz-msft · Accepted solution]

@Anonymous,

You could add a calculated table.

Calendar =
CALENDARAUTO ()