Forum Discussion
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
- Ashish_Mathur
Super User
Hi,
There could be one of the following reasons for you n ot getting your desired visual
- The data type of the new column is indeed text; and/or
- The dates in the Date table are byond the dates in the Date column of the Cultural Heritage table