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
That is a solution thank you! I don't understand why I couldn't join with InvDateTime. As I indicated early on, I need to improve on the fundamentals. If you can offer a brief explanation, I would be most appreciative. Otherwise, I will continue to study and improve.
I'm grateful for your time and effort.
Bob
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