Forum Discussion
Date filter problem.
I would rather prefer modeling data in Query Editor but SQL connection require credential.
I tried a fast solution just to show you the result. Please check if it is ok for your needs
Regards
What about this solution?
I did a workaround to overcome the credential issue. I created a flat files in DASX Studio using yout pbix and then I loaded in a new one.
Let me know
https://1drv.ms/u/s!Ah7_1Sua__g-6zkpOXZHDHM_iLmU?e=Sxx3ua
Sorry, I jumped the gun. I didn't relize that you used MyInvDate for the Date column. So, if you alter the date range using the date filter, you notice that the date filter has either no impact (if you change the last date) or n adverse impact (if you change the start date). Again, my apologies, if my line of questioning has been confusing.
Bob
Change the field in the visual. Substitute Date with MyInvDate
What about this solution?
I did a workaround to overcome the credential issue. I created a flat files in DASX Studio using yout pbix and then I loaded in a new one.
Let me know
https://1drv.ms/u/s!Ah7_1Sua__g-6zkpOXZHDHM_iLmU?e=Sxx3ua
Perfect! So it looks like I had to use query editor to split the date/time column and change the types to Date and Time respectively. Then join the Dates table on the new InvDate column of the vSalesHeader table.
Thank you for putting in a little extra time on my behalf.
Bob