Forum Discussion

v4anand18's avatar
v4anand18
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Creating a Custom Column

Hi All,   I am trying to create a custom column for one of my report using DAX but i am stuck. Please share your inputs.    My data looks like this Account No Acct Open Date Site ID Acct O...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI v4anand18,

     

    You can use below formula to get earliest date based on current group site id:

    Earliest Date =
MINX (
    FILTER ( ALL ( Table ), [Site ID] = EARLIER ( [Site ID] ) ),
    [Acct Open Date]
)

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI v4anand18,

 

You can use below formula to get earliest date based on current group site id:

Earliest Date =
MINX (
    FILTER ( ALL ( Table ), [Site ID] = EARLIER ( [Site ID] ) ),
    [Acct Open Date]
)

 

Regards,
Xiaoxin Sheng