cancel
Showing results for 
Search instead for 
Did you mean: 
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
JamesFr06
Super User
Super User

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.

JamesFr06
Super User
Super User

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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors