Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

2 date columns 2 status columns

Hi,

I have 2 staus columns i,e Current_Status & Approved_Status and I have separate date columns for each status as Current_Status_Date & Approved_Status_Date, I need to show both the staus in 2 different bar graphs and I should use a date column as a slicer, that date colum should be in month values.

DateNumberCurrent_StatusCurrent_Status_DateApproved_StatusApproved_Status_Date
01/01/2020ABC123In Review01/03/2020Approved01/02/2020
01/02/2020BCD123Cancelled01/04/2020  
01/02/2020DEF123Remediated01/03/2020Approved01/04/2020
01/03/2020EFG123Peniding Remediation01/05/2020  
01/03/2020GHI123Cancelled01/05/2020Approved01/04/2020
01/04/2020IJK123In Review01/05/2020  
01/06/2020LMN123Risk01/08/2020Approved01/05/2020
01/06/2020MNO123In Review01/08/2020Approved01/05/2020
01/06/2020NOP123Remediated01/08/2020Approved01/05/2020

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    I create a new column to get the date of [Updated] column and use it to replace [Updated] column in the inactive relationship with Date table.

     

    Updated Date = RADsNew[Updated].[Date]

     

    Then I create a measure to count the number with USERELATIONSHIP function and put it in the chart as value. You can change the name of this measure as you like.

     

    Measure = CALCULATE(COUNT(RADsNew[Number]),USERELATIONSHIP(Dates_Table[Date],RADsNew[Updated Date]))

     

     

    Please download the pbix here.

     

    Regards,

    Jing

7 Replies