Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help in time related DAX

Hey Experts,   I need help with dax.   I have two columns one is SALE DATE and one is ORDER DATE. I need one column or measure according below condition, Ever order date has multiple sale date. ...
Urgent Help with DAX
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Try it.

    result = 
VAR _min =
    CALCULATE ( MIN ( Data[Sale date] ),FILTER(ALLSELECTED('Data'),[Order date]=MAX([Order date])))
RETURN
    IF (
        MAX(  Data[Sale date] ) = _min,
        "Current",
        "Next")

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Please share your sample.

I think the sample that is described in your question is different than what you show in the reply.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sorry sir. Its my mistake. I applied some filter on page if i mention that filter in mymeasure its working fine. but my question is if i add more filter in future it automatically make my measure wrong. any solution for that sir>