Forum Discussion

ny326n's avatar
ny326n
Frequent Visitor
9 years ago
Solved

How to make an array formula in DAX?

Hello!   Earlier I've created a formula in Excel which I now want to translate into DAX, but can't manage to figure out how.    I have a table with all sales and these are some of colums: Assign...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi ny326n,

     

    Based on my test, the formula below should also work in your scenario. :smileyhappy:

    Column =
IF (
    Data[Date and Time]
        = CALCULATE (
            MIN ( Data[Date and Time] ),
            FILTER (
                ALL ( Data ),
                Data[Creator User ID] = EARLIER ( Data[Creator User ID] )
            )
        ),
    "New",
    "Resale"
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi ny326n,

 

Based on my test, the formula below should also work in your scenario. :smileyhappy:

Column =
IF (
    Data[Date and Time]
        = CALCULATE (
            MIN ( Data[Date and Time] ),
            FILTER (
                ALL ( Data ),
                Data[Creator User ID] = EARLIER ( Data[Creator User ID] )
            )
        ),
    "New",
    "Resale"
)

 

Regards

Rahul8993's avatar
Rahul8993
New Member
7 years ago

HI, v-ljerr-msft

 

Awesome solution, I had the same issue finally seen your post and got resolved. :-)