Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem connecting sales table to calendar table

Hi, 

I am connecting the sales table (called cultural heritage)  to the calendar table.

But when I create the visuals they are all empty.

 

I guess this is a problem with the data type.

 

In Power Query, I imported the tables using an API and from_date & to_date parameters of this type:

1/11/2021 12:00:00 AM +00:00
then I transform the column data type from text to date/tie/timezone

then, since I have 2 dates column, let's call them sales order and sales delivery, I create a third column (this time in PowerBI and not Power Query) which return the earliest of the 2 dates

Then I transform the new column to date type (instead of date/time) 

Then I connect it to the calendar table

There must be something wrong with one of these steps

 

Thank you!

 

1 Reply

  • Hi,

    There could be one of the following reasons for you n ot getting your desired visual

    1. The data type of the new column is indeed text; and/or
    2. The dates in the Date table are byond the dates in the Date column of the Cultural Heritage table