Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
My model is simple, a date table for filtering monthly reports, PL Service which is recording the services, Inserted date, Effective Date, & Closing Date, AM Table for service person name and ID.
There will be two different measures MidTermCancellations based on the inserted date and Cancellation based on the effective date:
But I get blank for the MidTerm Cancellation which should be 146:
The date filter is from the date table. Please guide me.
Solved! Go to Solution.
@timazarj , can you check InsertedDate has a timestamp. If so join might fail
create a date like
Date = [InsertedDate ].date
or
Date = date(year([InsertedDate ]),month([InsertedDate ]),day([InsertedDate ]))
Hello @timazarj
You can try few things.
1. Check the column format and make it date.
2. Mark the date table as a date table.
3. Check the min and max of both the Inserted Date and Effective Date and create the date table accordingly using min and max values.
4. Create an active relationship with the inserted date and modify the measure accordingly and check.
@timazarj , can you check InsertedDate has a timestamp. If so join might fail
create a date like
Date = [InsertedDate ].date
or
Date = date(year([InsertedDate ]),month([InsertedDate ]),day([InsertedDate ]))
Thank you, it worked.
Hello @timazarj
Can you please share your pbix file or sample data after removing the sensitive data?
Unfortunately no.
Hello @timazarj
You can try few things.
1. Check the column format and make it date.
2. Mark the date table as a date table.
3. Check the min and max of both the Inserted Date and Effective Date and create the date table accordingly using min and max values.
4. Create an active relationship with the inserted date and modify the measure accordingly and check.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |