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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors