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
My apologies. Try this link as I don't believe that credentials will be required for this one: https://1drv.ms/u/s!Agkx6hQs0NiX1A2HsUc2gNJ5snqS?e=fB5U2R.
Ultimately, there will be several filters but, for now, I need to see the invoice totals for each day/per person. I agree that there is likely a problem with the join, but I have been unable to isolate it. Everything looks good to me.
Happy to provide more clarity if necessary.
Thank you!
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
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)😎.
RegardsSorry, 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