Duplicate Dates showing in table

[gbarr12345]

Hi,

I have a table in power BY where I've created a relationship between 4 tables.

The calendar table was created via a calculated table and I created a calculated column called Pay Week Ended.

When I pull the data into the table 2 of the same date are appearing and when I combined the total for these tables it's the correct figure. For example, in the screenshot below of the table for the 9th of July, the 37801 & 1200 add up to 39001 which is the correct overall figure for that date. The table visualistion has the Pay Week Ended from the calendar table as the date field.

I'm hoping to just have one date where it has the numbers combined if anyone can help me?

All the other tables are linked to the calendar table through the date fields.

The table visualistion has the Pay Week Ended from the calendar table, the week number from the calendar table, the sum of operation amount from the bulk dispatch weekly table and the sum of total from the cost FY25 table.

I've attached sample PBIX of an attempt. Can anyone help me make it one of the dates instead of 2 of the same?

PBIX - https://drive.google.com/file/d/166rIbNIKu-wwhwvJXKI8yHZ4hfet-ATT/view?usp=sharing

Thanks in advance!

[Ashish_Mathur · Accepted solution]

Hi,

For the same week number, the dates are different and therefore those blank rows will appear.

[gbarr12345]

Perfect thanks for that Ashish