Slicer with 2 date (Approved Date & Testing Date)

[ciksha]

Hi,

How to use slicer that can filter 'Testing Date' & 'Approved Date'? 

E.g E.g I want to filter based on month 'January' . so when I click 'January' , table below will be like this: 

[amitchandak · Accepted solution]

@ciksha , You need to create a common date table, with month, year month year etc. Join with both dates. One join will be inactive. You can activate join using userelationship

assume Approve Date is inactive

calculate( Countrows(Table),USERELATIONSHIP ('Table'2[Approve Date], 'Date'[Date])),

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[ciksha]

Hi, 

I've tried and compare it with actual data. I've have testing on January but some are approved on February. My 'No. Plan1' shall filter by 'Testing date'. but the output I get, the slicer also filter at common date.

 Output: 

Approve Date is inactive. 

DAX : 

No. Plan1 = CALCULATE(

COUNTROWS(sortbycreateddate) ,

USERELATIONSHIP( sortbycreateddate[APPROVED DATE], 'Date'[Date]),

sortbycreateddate[Slip Category] = "Plan" && sortbycreateddate[DOCUMENT TYPE]="Delivery Confirmation Slip (DCS)"

)