The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Table 2 | Table 1 | |||||||||||||||||||||
Area/Region | Territory | District | Office | Contract No. | Equipment No. | NA CODE | Notif # | Work Date | TOTAL SA HOURS | Area/Region | Territory | District | Office | Contract No. | Equipment No. | Base Penalty value | % penalty | NA CODE | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | BRP | FL23011705470000214 | 1/17/2023 | 1.6 | A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | BRP | FL23020213350000200 | 2/2/2023 | 0 | A04 | B10 | D85 | 8510 | 4200008990 | M0052581 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | BRP | RP5133518069 | 2/6/2023 | 1.4 | A04 | B10 | D85 | 8510 | 4200008990 | M0052582 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | BRP | RP5132911652 | 2/6/2023 | 1.5 | A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052581 | BRP | PX010019331341 | 1/9/2023 | 1.4 | A04 | B10 | D85 | 8510 | 4200008990 | M0052584 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052581 | BRP | PX010019437121 | 2/14/2023 | 1 | A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052581 | BRP | RP5132911653 | 2/14/2023 | 1.4 | A04 | B10 | D85 | 8510 | 4200008990 | M0052588 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052581 | BRP | RP5133518070 | 2/14/2023 | 1.6 | A04 | B10 | D85 | 8510 | 4200008990 | M0052589 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052582 | BRP | PX010019331340 | 1/12/2023 | 1 | A04 | B10 | D85 | 8510 | 4200008990 | M0052590 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052582 | BRP | PX010019437120 | 2/13/2023 | 0.9 | A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052582 | BRP | RP5132911654 | 2/13/2023 | 1.4 | A04 | B10 | D85 | 8510 | 4200008990 | M0052592 | $ 358 | 30% | BRP | ||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052582 | BRP | RP5133518071 | 2/13/2023 | 1.4 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | BRP | PX010019352869 | 1/5/2023 | 0.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | BRP | PX010019483806 | 2/7/2023 | 0.7 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | BRP | RP5132911655 | 2/7/2023 | 1.2 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | BRP | RP5133518072 | 2/7/2023 | 1.4 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052583 | BRP | PX010019557858 | 3/6/2023 | 1.3 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052584 | BRP | PX010019270260 | 1/10/2023 | 0.9 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052584 | BRP | PX010019502182 | 2/15/2023 | 0.6 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052584 | BRP | RP5132911656 | 2/15/2023 | 1.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052584 | BRP | RP5133518073 | 2/16/2023 | 1.3 | Result visual I want | ||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | PX010019151787 | 1/6/2023 | 0.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | 71545832 | 1/25/2023 | 0 | Area/Region | Territory | District | Office | Contract No. | Equipment No. | Base Penalty value | % penalty | NA CODE | Work Date | TOTAL SA HOURS | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | 71572566 | 1/30/2023 | 0 | A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | $ 358 | 30% | BRP | Jan-23 | 1.6 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | 71593858 | 2/2/2023 | 0 | A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | $ 358 | 30% | BRP | Feb-23 | 2.9 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | PX010019224172 | 2/27/2023 | 3.3 | A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | $ 358 | 30% | BRP | Mar-23 | 0 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | BRP | PX010019294259 | 3/3/2023 | 0.4 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052588 | BRP | 71515639 | 1/19/2023 | 0 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052588 | BRP | PX010019151786 | 1/24/2023 | 0.4 | A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | $ 358 | 30% | BRP | Jan-23 | 0.5 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052588 | BRP | PX010019294258 | 3/6/2023 | 0.7 | A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | $ 358 | 30% | BRP | Feb-23 | 3.3 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052589 | BRP | PX010019154893 | 1/6/2023 | 0.6 | A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | $ 358 | 30% | BRP | Mar-23 | 0.4 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052589 | BRP | PX010019230087 | 2/17/2023 | 0.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052590 | BRP | PX010019154892 | 1/19/2023 | 0.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052590 | BRP | PX010019230088 | 2/17/2023 | 0.6 | A04 | B10 | D85 | 8510 | 4200008990 | M0052580 | $ 358 | 30% | BRP | Jan-23 | 1.2 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052590 | BRP | PX010019299535 | 3/8/2023 | 3 | A04 | B10 | D85 | 8510 | 4200008990 | M0052587 | $ 358 | 30% | BRP | Feb-23 | 0.6 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | PX010019139466 | 1/4/2023 | 1.2 | A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | $ 358 | 30% | BRP | Mar-23 | 42.2 | ||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | PX010019213357 | 2/9/2023 | 0.6 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/7/2023 | 8 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/7/2023 | 8 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/7/2023 | 2 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/8/2023 | 3.5 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/8/2023 | 7.1 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/8/2023 | 6.4 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052591 | BRP | RP5133670989 | 3/8/2023 | 7.2 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052592 | BRP | PX010019139467 | 1/9/2023 | 0.8 | |||||||||||||
A04 | B10 | D85 | 8510 | 4200008990 | M0052592 | BRP | PX010019213358 | 2/9/2023 | 0.6 | |||||||||||||
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.
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 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.
Thanks Greg , do you have any suggestions based on the data I sent
@Raj2410 Try:
Column = CONCATENATEX(SELECTCOLUMNS(RELATED('Table2'),"__Date",[Date]),[__Date],", ")
@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.