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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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