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
Datagulf
Responsive Resident
Responsive Resident

Power Bi relationships Not working

This question has been asked severally, but I have tried all solutions and have yet to get a breakthrough. 
I have a date table with a column as follows.

Datagulf_0-1690801414132.png
The date column is a date data type with no Time values

Datagulf_1-1690801608089.png

The code for the Date table is as follows:

Complete  Date = ADDCOLUMNS(

CALENDAR(MIN(ProjectsWIPReportFromApril2020[date_completed]), MAX(ProjectsWIPReportFromApril2020[date_completed])),

"Year", YEAR([Date]),

"Month Year Num", CONCATENATE(YEAR([Date]), FORMAT([Date],"MMM")),

"Month Num", Month([Date]),

"Month", FORMAT([Date], "MMM"),

"Quarter Num",FORMAT([Date], "Q"),

"Quarter", CONCATENATE("Q",FORMAT([Date], "Q")),

"Day", FORMAT([Date],"D"),

"Week", CONCATENATE("Week ",FORMAT([Date], "WW"))

)

 I am connecting to a table column that is a date column in One to many relationships and Single. I have tried BOth Relationships as well and it's not working either.

Datagulf_2-1690802135990.png

The data type of the column connecting to the date table  is the date  

What ami doing wrong?


5 REPLIES 5
DataVitalizer
Solution Sage
Solution Sage

Hi @Datagulf 

Select your Date Table and Mark it (Table Tools Tab) so Power BI can recognize it 

othy_bi_1-1690803510217.png


Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

Thanks @DataVitalizer , had already done this

If the issue keeps occuring, can you share a screen shot of the relation between tables and what you display in your visual. that would help more?

 

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

Datagulf_0-1690870070118.png

This is what it shows. @DataVitalizer 

Hi @Datagulf 
Do you mind sharing the pbix file with only the tables required?

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.