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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sellgren7
Frequent Visitor

Display all unique commonalities in a measure and minimum starting time in another measure

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 numberStarting timeLineDelivery unit
2332022-09-01 12:00Flow 11
2332022-09-01 12:10Flow 12
2332022-09-01 12:20Flow 23
2332022-09-01 12:30Flow 14
2332022-09-01 12:40Flow 15
2332022-09-01 12:40Folw 26

 

In the first measure i want to show:

Article numberPossible production lines
233Flow1, Flow 2

 

In the second measure i want to show:

Article numberFirst start time
2332022-09-01 12:00

 

In the displayed table in PBI i will only have one row for each article number

 

Please help me out 🙂

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Hi

 

PLease try yhis

this is the result with your datas

JamesFr06_0-1665074732882.png

And the 2 measures are :

Possible production lines =
        CONCATENATEX (
            CALCULATETABLE ( VALUES ( Feuil1[Line] ) ),
            Feuil1[Line],
            ", ")
 
Minimum date =
min(Feuil1[Starting time])
 
Hope it helps !

View solution in original post

tamerj1
Super User
Super User

Hi @Sellgren7 

please try

 

Production Lines =
CONCATENATEX (
    VALUES ( 'Table'[Line] ),
    'Table'[Line],
    ", ",
    'Table'[Line], ASC
)
Start Time = 
MIN ( 'Table'[Starting Time] )

 

 

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

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.

Anonymous
Not applicable

Hi

 

PLease try yhis

this is the result with your datas

JamesFr06_0-1665074732882.png

And the 2 measures are :

Possible production lines =
        CONCATENATEX (
            CALCULATETABLE ( VALUES ( Feuil1[Line] ) ),
            Feuil1[Line],
            ", ")
 
Minimum date =
min(Feuil1[Starting time])
 
Hope it helps !

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.