Forum Discussion

Kieran_choudary's avatar
Kieran_choudary
Icon for Helper I rankHelper I
9 years ago
Solved

Help please my date table wont work

Hi I am new to Power BI and DAX, so please bear with me,

 

I am trying to create a MOM and WOW and YOY function and came to understand i would need a date table to do so, 

i have tried many different ones and methods i found in forums but none seem to work for me,

 

PLease see the pictures below and see if you can figure out why

 

This is my sales datamy date tablethe relationshipthe outputthe relationship

 

Please help me, ive at it for 3 days now trying different ways

Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Kieran_choudary

     

    If you order date has time the relationship won't work because PBI can't find an exact column.

     

    Not is the Same

     

    Order Date  

     

    01/01/2017 15:20  

     

    Calendar Date

     

    01/01/2017

14 Replies

  • alanhodgson's avatar
    alanhodgson
    Icon for Solution Supplier rankSolution Supplier
    9 years ago

    Hey Kieran_choudary,

     

    Your relationship looks good and I was able to recreate your calendar table. Let's test to make sure the relationship is working properly. Can you put the dates in a table and share the screenshot, like below? The first is from my "Source" table, the second date is from my "Calendar" table.

     

    Cheers,

     

    Alan

     

     

  • Kieran_choudary's avatar
    Kieran_choudary
    Icon for Helper I rankHelper I
    9 years ago

    Tried changin both to date/time still no luck

     

    Here is the table\

     

     

    Thanks for you help!