Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help with DAX ( Return specific date)

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....
@Dax
DAX ALL PowerBI Excel
DAX Calculation
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:
FreemanZ's avatar
FreemanZ
Super User
3 years ago

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: