Forum Discussion

bob57's avatar
bob57
Helper IV
5 years ago
Solved

Date filter problem.

Good day, I am unable to get the date table to interact with the data table. Here is a link to the .pbix: https://techservicesllc-my.sharepoint.com/:u:/p/bstorie/Ed6I54AMjxdNiEWDPBZXBgEByyey3TzZZHO...
Need Help
gpiero's avatar
gpiero
Skilled Sharer
5 years ago

Hi bob57 

 

Can youl help me to clarify which Date you wanto to display?

I suppose there is a issue in the join among table.

 

If you select CtrmID = "ALF" you will find 2004 rows and several InvDateTime for those rows.

 

Which date you would like to display? the earliest? the latest?

I can't edit your model to help you since credential are required

 

Regards

bob57's avatar
bob57
Helper IV
5 years ago

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!

    • bob57's avatar
      bob57
      Helper IV
      5 years ago

      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

      • gpiero's avatar
        gpiero
        Skilled Sharer
        5 years ago

        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