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
ani_informa
Helper III
Helper III

Relation between Date and Fact tabl

Hi

 

My Power BI desktop model contains one date dimension table (DimDate) and there are two fact tables (FactSales, FactTrans). There is relationship between DimDate table and 2 fact tables  (Many to One i.e. many in fact and one in dimension). when I am trying to pull measures from FactSales and FactTrans and Date from DImDate on axis to show trend, it is not showing any trend. So seems relation is not working. Both the measures are using simple SUM agg function. This looks strange because it is straight forward. Any help would be highly appreciated.

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @ani_informa  ,

 

In Dax, the date can be of the date or date/time type. You can check whether the data type in your table is one of these two, to prevent it from being a text type, confirm the date column in all your tables ,the data types are all the same.

 

And if the data type of the date column in one table is "date", and the data type of the date field in the other table is "date/time", an error that does not work will occur.

 

If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

PhilipTreacy
Super User
Super User

HI @ani_informa 

Please share some data so we don't have to recreate it.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


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.