cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HZAFAR
Regular Visitor

build Relationship Problem

Dear Team,

I have three different data-sheet in Power Bi and trying to build a relationship based on the date dimension table but facing the below error.
scenario
When I use each table wk# to create a visual in PBI, the data spread is correct for each data sheet week on week basis.
However, when I create many to many relationships (suggested by Power query automatically and without any other option), the table visual or line chart shows the total quantity only each week instead of each week's quantity. Kindly see below some sample data tables.

HZAFAR_0-1659132299193.png

 

HZAFAR_1-1659132891149.png

 

2 REPLIES 2
AUDISU
Resolver II
Resolver II

Hi @HZAFAR ,

Create a calender table. Build all relationships with this calender table and check.

Use following DAX code to create calender table.

Calender = CALENDAR (DATE (2022, 1, 1), DATE (2023, 12, 31))

 

Thank you.

This is not working.

 

secondly i need to create week number and DAX function is not giving me the correct wek day as complared to excel based formula (=ISOWEEKNUM(Date)

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.