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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Raj2410
Helper I
Helper I

Need help

One table has unique value and other table has multiple dates for the unique value how to bring the multiple value to one coloumn in a new table

7 REPLIES 7
Raj2410
Helper I
Helper I

Table 2  Table 1  
Area/RegionTerritoryDistrictOfficeContract No.Equipment No.NA CODENotif #Work DateTOTAL SA HOURS  Area/RegionTerritoryDistrictOfficeContract No.Equipment No.Base Penalty value% penaltyNA CODE  
A04B10D8585104200008990M0052580BRPFL230117054700002141/17/20231.6  A04B10D8585104200008990M0052580 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPFL230202133500002002/2/20230  A04B10D8585104200008990M0052581 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPRP51335180692/6/20231.4  A04B10D8585104200008990M0052582 $                      35830%BRP  
A04B10D8585104200008990M0052580BRPRP51329116522/6/20231.5  A04B10D8585104200008990M0052583 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPPX0100193313411/9/20231.4  A04B10D8585104200008990M0052584 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPPX0100194371212/14/20231  A04B10D8585104200008990M0052587 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPRP51329116532/14/20231.4  A04B10D8585104200008990M0052588 $                      35830%BRP  
A04B10D8585104200008990M0052581BRPRP51335180702/14/20231.6  A04B10D8585104200008990M0052589 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPPX0100193313401/12/20231  A04B10D8585104200008990M0052590 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPPX0100194371202/13/20230.9  A04B10D8585104200008990M0052591 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPRP51329116542/13/20231.4  A04B10D8585104200008990M0052592 $                      35830%BRP  
A04B10D8585104200008990M0052582BRPRP51335180712/13/20231.4             
A04B10D8585104200008990M0052583BRPPX0100193528691/5/20230.5             
A04B10D8585104200008990M0052583BRPPX0100194838062/7/20230.7             
A04B10D8585104200008990M0052583BRPRP51329116552/7/20231.2             
A04B10D8585104200008990M0052583BRPRP51335180722/7/20231.4             
A04B10D8585104200008990M0052583BRPPX0100195578583/6/20231.3             
A04B10D8585104200008990M0052584BRPPX0100192702601/10/20230.9             
A04B10D8585104200008990M0052584BRPPX0100195021822/15/20230.6             
A04B10D8585104200008990M0052584BRPRP51329116562/15/20231.5             
A04B10D8585104200008990M0052584BRPRP51335180732/16/20231.3  Result visual I want
A04B10D8585104200008990M0052587BRPPX0100191517871/6/20230.5             
A04B10D8585104200008990M0052587BRP715458321/25/20230  Area/RegionTerritoryDistrictOfficeContract No.Equipment No.Base Penalty value% penaltyNA CODEWork DateTOTAL SA HOURS
A04B10D8585104200008990M0052587BRP715725661/30/20230  A04B10D8585104200008990M0052580 $                      35830%BRPJan-231.6
A04B10D8585104200008990M0052587BRP715938582/2/20230  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-232.9
A04B10D8585104200008990M0052587BRPPX0100192241722/27/20233.3  A04B10D8585104200008990M0052591 $                      35830%BRPMar-230
A04B10D8585104200008990M0052587BRPPX0100192942593/3/20230.4             
A04B10D8585104200008990M0052588BRP715156391/19/20230             
A04B10D8585104200008990M0052588BRPPX0100191517861/24/20230.4  A04B10D8585104200008990M0052580 $                      35830%BRPJan-230.5
A04B10D8585104200008990M0052588BRPPX0100192942583/6/20230.7  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-233.3
A04B10D8585104200008990M0052589BRPPX0100191548931/6/20230.6  A04B10D8585104200008990M0052591 $                      35830%BRPMar-230.4
A04B10D8585104200008990M0052589BRPPX0100192300872/17/20230.5             
A04B10D8585104200008990M0052590BRPPX0100191548921/19/20230.5             
A04B10D8585104200008990M0052590BRPPX0100192300882/17/20230.6  A04B10D8585104200008990M0052580 $                      35830%BRPJan-231.2
A04B10D8585104200008990M0052590BRPPX0100192995353/8/20233  A04B10D8585104200008990M0052587 $                      35830%BRPFeb-230.6
A04B10D8585104200008990M0052591BRPPX0100191394661/4/20231.2  A04B10D8585104200008990M0052591 $                      35830%BRPMar-2342.2
A04B10D8585104200008990M0052591BRPPX0100192133572/9/20230.6             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20238             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20238             
A04B10D8585104200008990M0052591BRPRP51336709893/7/20232             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20233.5             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20237.1             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20236.4             
A04B10D8585104200008990M0052591BRPRP51336709893/8/20237.2             
A04B10D8585104200008990M0052592BRPPX0100191394671/9/20230.8             
A04B10D8585104200008990M0052592BRPPX0100192133582/9/20230.6             
                       
Raj2410
Helper I
Helper I

@Greg_Deckler 

 

Thank you for your reply.

I am going to do my best to explain the data and situation with sampple.

 

This is what i have , Two tables.

Table 1 is my BASE table and table 2 can be considered my result table.

One problem is table 1 doesnot have any date coloumn.

 

Raj2410_0-1679247090275.png

The relation between table 1 and table 2 is created.

 

I want to create a visual where all equipment numbers exist all 1324 weather they have a work date or not.

I created a sample visual below that I want. I have tried creating a new summarize table from table 2 but every time I use a month filter it filters out the equipment numbers from table 1 that have no work date.

Hope you can help.

 I will attache the file that I am using.

 

 

Raj2410_2-1679247654746.png

 

 

@Raj2410 OK, so the big problem here is how are you differentiating those different groups that you have highlighted? There needs to be something that tells DAX or the visual that those rows are separate things. I don't see anything in your visual or the data that could tell DAX or the visual that the first 4 rows belong together, then the middle 6 rows belong together and then the last 9 rows belong together.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thanks Greg , do you have any suggestions based on the data I sent

 

Greg_Deckler
Community Champion
Community Champion

@Raj2410 Try:

Column = CONCATENATEX(SELECTCOLUMNS(RELATED('Table2'),"__Date",[Date]),[__Date],", ")


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler thank you my table 1 that has unique value does not have dates

 

@Raj2410 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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