Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
RaulPBI
Helper II
Helper II

PROBLEMS WITH TIME INTELLIGENCE

Hello everybody.

 

I have a problem with a model. It contains only three tables, one of them is date, and the rest are fact tables, costs by date and shipments by date. The thing is that I am not able to "draw" in Power BI total shipments by date using date table, it does not work. Any idea?

Spoiler
 

 

1 ACCEPTED SOLUTION

Hi,

 

I have solved it by this way:

 

I have created another column in fact table which is date too, like this:

 

Calculated date = albaran_salida_fechas[create_date].[Date]

 

then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.

 

Thanks for your time

View solution in original post

6 REPLIES 6
TomMartens
Super User
Super User

Hey,

 

can you please be a little more specific what you mean by "It does not work"

 

Check the following

  • are the tables related
  • ideally both columsn should be of datatype "date" sometimes it might happen, that the column from the fact table (cost or shipment) contain time information, whereas the date column of the calendar table might not match 12:00AM

 

Cheers

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

1. tables are related for sure

2. both columns have the same format

 

What I mean is that if I want to calculate shipments by date in a column chart for example, the chart does not show what I need. Instead of that show all data in "blank" date, not in each real date.Captura.PNGCaptura1.PNG 

Hey,

 

my assumption:

the x-axis is picked from your table calendario.

 

Both tables are joined "Calendario-Date" <- "albaran...create_date" (the fact table).

 

The fact that all your data is shown on the element "(blank)", that for sure doesn't exists in the table Calendario, indicates that there is no match between the values of the joined columns.

 

This may happen if your Date column from the Calendario table is of datatype datetime "2017-08-10 12:00:00" and your column create_date is also a datetime column, but the values do not have a time portion like so: "2017-08-10 00:00:00"

 

This means, there are no matching values in both columns. For this reason I really recommend that you define the same datatye "date", this is different than the format used to present the values from the columns:

 

Datatype Date.png 

 

Hope this helps

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

I understood your last reply.

 

Both columns have same datatype "date" in this case, so I don't know why it does not show what I want.

Hey,

 

so it seems, that you have to provide sample data, from where your problem can be reproduced.

 

Regards



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi,

 

I have solved it by this way:

 

I have created another column in fact table which is date too, like this:

 

Calculated date = albaran_salida_fechas[create_date].[Date]

 

then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.

 

Thanks for your time

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.