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/Ed6I54AMjxdNiEWDPBZXBgEByyey3TzZZHOYu73PscC9KQ?e=rR7GM6

Notice that dates do not appear in the Date column in the below table visualization. Also, if the start date is changed to a date other than 6/1, all data in the InvTotal and Full Name columns disappear (the full date range is 6/1 - 7/6). I'm sure I lack a fundamental understanding that has prevented me from successfully debuging. I hope you're willing to help.

Thank you for your time and effort.

Bob

Need Help

11 Replies

  • 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!