Need help with DAX ( Return specific date)

[Anonymous]

Hello,

I need your help.

I have sales data as follows:

I need to create a dax measure to return a date.

Result should be the date when Running total >= Target (60)

Thanks in advance. 

[Anonymous]

Thanks @FreemanZ, thats exaclty what I was looking. 

[v-yinliw-msft]

Hi @Anonymous ,

You can try this method:

New a measure:

Result = CALCULATE(SUM('Sales'[Target Date]), 'Sales'[Running Total] >= 60)

The result is:

And there is another mothed to solve your problem:

Hope this helps you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ · Accepted solution]

try to create a measure with the code below:

Measure =

VAR Table1 =

    CALCULATETABLE(

        VALUES(TableName[Date]),

        TableName[RT]>=60

    )

RETURN MINX(Table1, TableName[Date])

i tried and it worked like this: