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:

3 Replies

  • 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:
  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks FreemanZ, thats exaclty what I was looking.