Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Table relationship issue

Date Table relationship issue https://1drv.ms/u/s!AhVscPhmToJ0k7gcVSus_llQdKYNKQ   When I use date-time column (CreatedOn.1) in existing table, column chart visual is working well.   I cre...
Need Help
  • richbenmintz's avatar
    richbenmintz
    7 years ago

    Hi Anonymous

     

    your createdOn.1 Column contains time, when you join to the Date table you are not matching any of the dates there, can you create a column that is just the date portion in your source system or through power query?

     

    You will find your pbix file updated with a calc column that joins to the date table to slices your data by date, I would not suggest joining on calc dax columns and would try to push creating column work to your source system or powery query

     

    https://1drv.ms/u/s!AhCeuF2piSWMgcBRvlzvUfBvxtNL5A

     

    I Hope this helps,

     

    Richard

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ah, beat me to it richbenmintz :smileysurprised:

 

anyhow, if you fix the created on column to:

Column = FORMAT('1 pune'[CreatedOn.1],"MM/DD/YYYY")

and join that to the date table, it will work

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey richbenmintz I just extracted date portion in power query and it works!

 

Anonymousthanks, that works too.