Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks all for support in advance,
I have one issue with finding Launch date of Product based on selections.
I Group,Product,FirstLaunch and country as fields
Group | Product | Country | FLDate |
G1 | P1 | India | Jan-2015 |
G1 | P1 | Canada | Mar-2019 |
G1 | P1 | Japan | Nov-2017 |
G1 | P1 | Chaina | Dec-2016 |
G1 | P1 | Pakistan | Mar-2018 |
G1 | P2 | India | May-2016 |
G1 | P2 | Canada | Jul-2017 |
G1 | P2 | Japan | Feb-2018 |
G1 | P2 | Chaina | Dec-2019 |
G1 | P2 | Pakistan | Jan-2015 |
G2 | P3 | India | Jan-2017 |
G2 | P3 | China | Mar-2017 |
G2 | P3 | USA | Dec-2018 |
I have Group ,Product and country filter i want to show a FirstLaunchDate based on selections in a KPI.
Country filter is multiselecting filter , when multiple countries are selected i want to show min of FLDate
Thanks all once Again
HI @kmmqlick
Try like below
Min(FLDate)
If @MayilVahanan does not work then try this.
=Date(Min(date#(FLDate, 'MMM-YYY')) , 'MMM-YYYY')
Thank you @MayilVahanan and @Vegar for your response.
I am not getting in month-year format for your expressions.
i used Date(MinString(FLDate),'MMM-YYYY') it is working fine