Forum Discussion
Filter on start and end dates
- 1 year ago
Hi _bs_
You need to duplicate your current date table and keep it disconnected (no relationships).
Add the date from this disconnected table to a slicer
Create another table as follows
DateTypeSelector = DATATABLE("DateType", STRING, {{"CreatedDate"}, {"EndDate"}})Add this to a slicer
Now create a measure that respects the selected date type, edit to fit your tables
SelectedDateType = SELECTEDVALUE(DateTypeSelector[DateType]) TicketsOpened = CALCULATE( COUNTROWS(FactTickets), FILTER( FactTickets, IF( SelectedDateType = "CreatedDate", FactTickets[CreatedDate] IN VALUES(DisconnectedDate[Date]), FactTickets[EndDate] IN VALUES(DisconnectedDate[Date]) ) ) )You can use this for ticketsclosed as well.
This will work independantly of other relationships.
I hope this helps, please give a thumbs up and mark as solved if it does, thanks!
Hi _bs_,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to wardy912 , Ashish_Mathur and MohamedFowzan1 for prompt and helpful responses.
Just following up to see if the responses provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar