Forum Discussion

NiugeS's avatar
NiugeS
Icon for Helper V rankHelper V
6 years ago

If Filtered Date is Smaller then blank

Hi all,   Apologies if this is simple but i'm still learning.     I have a table that contains issues (support tickets).  Sometimes these are resolved after the report period and I am trying to f...
Need Help
NiugeS's avatar
NiugeS
Icon for Helper V rankHelper V
6 years ago

az38 Apologies if I copied the wrong file link.  I've updated the original message.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

NiugeS 

much better

1 set Active "Show tems with no data" for [Key] field in Visualizations pane

2 re-write your measure

Measure 2 = 
var _Created = MIN('Issues'[Created])

RETURN
If(_Created > CALCULATE(MIN('Created Date'[Date])), BLANK(), SELECTEDVALUE('Issues'[Created]) )

 

but Im not sure I understand your condition logic correct

 

  • NiugeS's avatar
    NiugeS
    Icon for Helper V rankHelper V
    6 years ago

    az38 I think I should shut down the laptop for the night!  I didn't explain my logic correctly ... i wanted resolved date as you probably guessed!  


    I will work on the suggestion you provided and see if I can make sense of it.  Thank you.

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    NiugeS 

    Measure 2 = 
var _Created = MIN('Issues'[Created])
var _Resolved = MIN('Issues'[Resolved Date])

RETURN
If(_Created > _Resolved , BLANK(), _Created )
  • NiugeS's avatar
    NiugeS
    Icon for Helper V rankHelper V
    6 years ago

    az38 

    Thank you for your help.  I modified your previous suggestion before seeing the new one.  The below seems to provide the desired results.  Thank you for all your help.  I'll try the other measure as well - thanks.

     

     

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    NiugeS 

    good luck! have a good night 🙂