Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello
I have worked for some time now to try to write a measure i DAX that will look through a column and display all unique values based on data in another column. I have several article numbers that can be produced in several lines depending on the final delivery unit. For this article number i want to display all possible routes that part can go.
I also want to show the minimum value of starting time for that article number in another measure.
As an example i have these columns
Article number | Starting time | Line | Delivery unit |
233 | 2022-09-01 12:00 | Flow 1 | 1 |
233 | 2022-09-01 12:10 | Flow 1 | 2 |
233 | 2022-09-01 12:20 | Flow 2 | 3 |
233 | 2022-09-01 12:30 | Flow 1 | 4 |
233 | 2022-09-01 12:40 | Flow 1 | 5 |
233 | 2022-09-01 12:40 | Folw 2 | 6 |
In the first measure i want to show:
Article number | Possible production lines |
233 | Flow1, Flow 2 |
In the second measure i want to show:
Article number | First start time |
233 | 2022-09-01 12:00 |
In the displayed table in PBI i will only have one row for each article number
Please help me out 🙂
Solved! Go to Solution.
Hi
PLease try yhis
this is the result with your datas
And the 2 measures are :
Hi @Sellgren7
please try
Production Lines =
CONCATENATEX (
VALUES ( 'Table'[Line] ),
'Table'[Line],
", ",
'Table'[Line], ASC
)
Start Time =
MIN ( 'Table'[Starting Time] )
Hi @Sellgren7
please try
Production Lines =
CONCATENATEX (
VALUES ( 'Table'[Line] ),
'Table'[Line],
", ",
'Table'[Line], ASC
)
Start Time =
MIN ( 'Table'[Starting Time] )
Thanks for the quick response and the help, unfortunalely this only solved a part of my problem but i think i need to create a new post for the root problem that im unable to solve.
Hi
PLease try yhis
this is the result with your datas
And the 2 measures are :
Thanks for the quick response and the help, unfortunalely this only solved a part of my problem but i think i need to create a new post for the root problem that im unable to solve.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
19 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
22 | |
18 | |
15 | |
11 |