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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SylvainP
New Member

Problem getting information from 2 tables with a common date

Hey PowerBI experts,

 

I am new to it and watch a lot of videos to help me learn but I am kind of blocked on this one.

 

I have 3 tables I use that are connecting through the Equipment column.

 

I have an issue with data accuracy. I use a slicer to be able to sort a specific period.

Basically, if I use the date from EMMC1 in the slicer, the ActCost is accurate but the Amount from EMRB2 is not and if I use the date from EMRB2 in the slicer, my Amount is accurate but my ActCost from EMMC1 is not.

 

So I created a CalendarTable to combine the dates hoping it would resolve my issue but it didn't.

I don't know if I am doing something wrong or if I miss a step.

 

SylvainP_0-1678293001878.png

 

Link to my file 

 

Thank you guys,

 

S

 

 

2 REPLIES 2
YukiK
Impactful Individual
Impactful Individual

Create a relatioship between EMEM1 and EMMC1 and use a slicer using a date from EMEM1. Now that should filter both EMMC1 and EMRB2. Make sure you're using the correct dates for your relationship

I can't use the date from EMM1 as they are purchased date or job date.

 

The dates from EMRB2 and EMMC1 are usage dates.

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.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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