topic Need help with DAX ( Return specific date) in DAX Commands and Tips

Need help with DAX ( Return specific date)

Anonymous — Mon, 28 Nov 2022 23:20:20 GMT

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.

FreemanZ — Tue, 29 Nov 2022 00:14:10 GMT

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:

v-yinliw-msft — Tue, 29 Nov 2022 05:31:41 GMT

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.

Anonymous — Tue, 29 Nov 2022 19:38:49 GMT

Thanks FreemanZ, thats exaclty what I was looking.