Forum Discussion
Modify DayOffset Slicer
I've solved the issue by adding a blank query called "Now" that specifies the timezone and then referencing that "Now" query in the Date table i.e. the "Current date" step in power query.
Solution Specialist[line] is another measure,
line= countrows(dw_orders)
vapid128 , you have date table linked to one table for your example so countrows will be for 'dw_orders' table only. I will be linking to multiple tables - how do I accomplish that?
- vapid128
Try make all relationship cross filter diretion both.
If it does not work, can you pos all your table relationships?
vapid128 I'm not comfortable setting cross filter to 'both' direction as it may cause ambiguity with results when filtering. I direct messaged you with link to pbix file. Hope that's okay.
- vapid128
If you report or dateset refresh daily,
we can try build today() function in colnum.
And numbers refresh daily.