Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot convert Arrive date to date in my FACT Table

Hi Experts

 

i am trying to link my calendar table to my FACT table via Date (cal) and Arrival Date (FACT) but i cannot convert the column to date...

 

see sample file.

https://www.dropbox.com/s/f4ro05kvd7mkrgm/Template.pbix?dl=0 

 

 

Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Anonymous ,

    You're facing this issue because the date range on your calendar table and your fact table are different. 
    Your calendar table starts from 01/01/2016, while the data in your fact table is from 2011 to 2013. 
    This is why even when nothing is selected on the date filter you're seeing blank values on the visual.

    Calendar table

     

    Fact table 


    In power query, the startdate parameter on your calendar table is set to "01/01/2016". Modify this to "01/01/2011" and then load the data to report view again.

    Once you do that you will start seeing data on your visual as shown

     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

3 Replies

  • rohit_singh's avatar
    rohit_singh
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous ,

    Sorry I don't understand the issue here. Arrival date is in the correct format and the relationship between the fact table and the calendar table is also correct.

     

     



    Could you please explain the issue in more detail? or what you're trying to achieve?

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂



     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ok Rohit.....Add to the visual in the exec summary Date to the slicer from Calendar table and then add Arrival Time to the Rows in Matrix table and the count to the values and the weekdays to the columns.....its not giving an end result.

    • rohit_singh's avatar
      rohit_singh
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi Anonymous ,

      You're facing this issue because the date range on your calendar table and your fact table are different. 
      Your calendar table starts from 01/01/2016, while the data in your fact table is from 2011 to 2013. 
      This is why even when nothing is selected on the date filter you're seeing blank values on the visual.

      Calendar table

       

      Fact table 


      In power query, the startdate parameter on your calendar table is set to "01/01/2016". Modify this to "01/01/2011" and then load the data to report view again.

      Once you do that you will start seeing data on your visual as shown

       

      Kind regards,

      Rohit


      Please mark this answer as the solution if it resolves your issue.
      Appreciate your kudos! 🙂