Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there any easy way to sync these two always show the same date?
create a separate date field that has joins with these two and create a single slicer. Why do you need 2 slicers if they're supposed to show the same values?
i need to create the relationship between Rev by Territory to Date and Query 1 to date but obviously unable to do this?
assuming the existing joins are on the Order ID you should be able to do this when you switch the order of existing joins to single direction rathen than both
thank you, but i need to be able to filter both ways otherwise it messes with the numbers i need
1 looks at the date something was invoiced the other looks at MRR date looking at each month, i have tried to do the date table then relationship but because i already have relationships between the other tables am unable to do this