Forum Discussion

Emranit's avatar
Emranit
Helper II
1 year ago

Need one value from same multiple value for every machine under every date

A DAX need where i will select one date from queue time and select one Machine no from machine. Then MC loading capacity show same multiple value. Here I need one value instead of same multiple value...
Need Help
Emranit's avatar
Emranit
Helper II
1 year ago

https://docs.google.com/spreadsheets/d/1H8aF0qeidZr2v0dxrJfaxx-kSbk0Kgcq/edit?usp=sharing&ouid=113914284006601104314&rtpof=true&sd=true 

 

I have a DAX which calculate the Maximum RunTime in Minutes among the 10 number of RunTime
from the Excel file.

Now I need a DAX which visualize that column Bulk_Production and Dyelot No according to maximum
RunTime. Like:-

## If maximum runtime 549 then visualize from same column
Bulk_Production 597
Dyelot 250890013

Can you do it from the attached Excel file ?

 

Actually I need which Dyelot run maximum time, according to maximum runtime need Bulk_production quantity & Dyelot no. Then I'll able to understand why this dyelot need to run long time and calculate with prduction.