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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Data_SuperHero
New Member

Date column matching between tables

Hi All,

 

I'm new to Power BI I recently started using it, and currently I'm tryng to find out how can I possibly use this for data validation /  to validate if columns like "Start/Signature Date" "End / Delivery Date" "Supplier Segmentation Tier" & "Supplier has access to Information" data from one table (which is the target) are correct. These has to be compared to 3 sources from where this data is from. These soures has the same data type columns (but their column name might be just a bit different) so that I can validate that the target has the correct data . Is there a way to do this matching? I would appreciate any help from you guys.

 

I have cleaned the data a bit in Power Query made sure that when these where imported all the columns in the target table had the correct data type and also for the source tables as well.

 

And also is there a way when for exmale some rows from the target table's columns do not match or is null to show/highlight this?  

3 REPLIES 3
PhilipTreacy
Super User
Super User

Hi @Data_SuperHero 

 

The short answer is yes, this sounds do-able.

 

But without seeing your data and knowing exactly how you want to 'validate' the data, it's difficult to give you any examples of how to implement it.

 

If you can provide samples of your data as tables/files (not pictures) and explain in detail what you want, I'll see what I can do.

 

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!


This is how my data model looks like at the moment:

 

The first one is the target table  which has those 4 columns with data which need to be validated/ matched with the columns I have mentioned in my  above comment which are from data sources 2, 3, and 4.

 

Data_SuperHero_0-1687871121208.png

 

Hi Philip, Thanks for taking your time reading this, and also coming back to me, unfortunately I'm unabe to share any sample of this data as this by nature is quite senstive, it would a large excel file type extract with contracts table with multiple columns and I would need to validate the above columns OR match them against 3 data sources:

 

1.First data source would be a "Commercial Impact Forms (CIF)" where I need to validate the "Start/Signiture Date" column data from the contract table against the "Effective Date"  which is from the CIF table from this source  (these are date data types)

 

Again from contract table two more columns: 

Supplier has access to confidential, sensitive and critical Information data column against ->Does the supplier have access to confidential / sensitive / critical information?(CIF table) - (these columns are text date types)

 

From the contracts table now I need to compare the:

 

End / Delivery Date (For open ended contracts enter 01/01/2099) column to a column called  ->  Actual End Date in (Pipeline extract table)

 

And a last data column from the contract table called: Supplier Segmentation Tier

 

Needs to be compared to a data column called Tier (Final), which sits in a Segmantation Tier table 

 

Hope it makes sense, so this is what I'm trying to figure out, so far I figured out that I need to create a relationship between these tables n order to be able to the matching.

 

Would this be a one to many relationship I need?

 

I would appreciate any help at this point! Thanks again!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors