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
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
Hi,
just some little improvement
https://1drv.ms/u/s!Ah7_1Sua__g-6zkpOXZHDHM_iLmU?e=G5rivv
Regards
P.S.: please check at your PM inbox