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
I am not completely sure, but an explanation could be an issue related to data type.
For this reason I tried to apply the split option using Transform in Query Editor. I wanted to divide datetime field ito only date.
But I had not the access due credential.
I did a lot of PBI report from Sharepoint workflow list since 2016 and I always adopted this strategy. I rather prefer to have the complete control of the data even if it could mean to adopt a solution considered not up to date.
I always put in join a field Date from Calendar table with field Date from Share point list.
You know, we use to say that "Experience is the result (or the sum) of the kick off in your bottom)😎.
Regards