Forum Discussion
issue with Date table in directquery
Anonymous
I am not sure how you have applied the month filer and when you say "Not working", it is not clear enough. Please share a sample file and provide an explanation.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š
@Fowmy Thank you for your reply.
The month filter (from Date table) is not working with table visual. it is showing blank. Month filter is not being applied.
Table fields are from SLA_Summ table.Even if I choose 'DateKey' filter(from date table), filter does not apply.
https://1drv.ms/w/s!AmG6mTfolVuyg108gGVM0G0fgwRk?e=gV7GQF
(Shared the screen shots in attached document, somehow not able to upload here.)
Date Query - used to create date table in SQL server.
https://1drv.ms/t/s!AmG6mTfolVuyg2IjpHlpNnu08l4S?e=w4cMnL