Forum Discussion

newbie7's avatar
newbie7
Frequent Visitor
5 years ago
Solved

Data shaping issue

hello experts, Need some help what i have been trying to resolve forwhole day, but could not.  column1                  Date1           Date2 Customer1   03/12/2010    06/09/2013 Custermer1   06/...
Need Help
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    Here's some DAX for a calculated column

     

    Table[NewDate2] =

    VAR _CurrentDate1 = 'Table'[Date1]
    RETURN
    CALCULATE(
    MIN('Table'[Date2]),
    ALLEXCEPT('Table', 'Table'[Column1]),
    'Table'[Date2] > _CurrentDate1
    )
PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

Here's some DAX for a calculated column

 

Table[NewDate2] =

VAR _CurrentDate1 = 'Table'[Date1]
RETURN
CALCULATE(
MIN('Table'[Date2]),
ALLEXCEPT('Table', 'Table'[Column1]),
'Table'[Date2] > _CurrentDate1
)
newbie7's avatar
newbie7
Frequent Visitor
5 years ago

dax is working, i just added >= as there were a few same dates. Thanks much