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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jorismo
Helper II
Helper II

Enter values from 2 tables in 1 table

Hi all,

 

I woul like to enter values from 2 different tables into 1 visual table.

 

So what I want is the visual table contains all the tables like the contains now and 1 additional kolum from Saviom[Start Time].

The next step is to create an conditional formatting on the field General [first login].

If the General [First login] is previous that the Saviom [Start Time] then noting must be happend, otherwise the field must become red.

 

Hope someone can help me.

 

Link to my current BI

https://drive.google.com/open?id=1DrkBXZy5mVRSrxvkZlUjZUe1Y_TFqcgU

3 REPLIES 3
v-sihou-msft
Employee
Employee

@jorismo

 

In your report, your Saviom and General tables are actually under "Many to Many" relationship. So the Saviom[Start Time] can't get the "1 to 1" mapping General [First login] values to apply condition. 

 

Regards,

ok,

 

and how will I get it working? I need the time of first logon and saviom time in the same table.

 

Eventualy I'll drop the conditional formatting but really need to get the 2 things into 1 table

no one with an sollution?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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