Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Date/Time Intelligence Formula

I am trying to write a filter for a [Due Date] column within my dataset, I have a [DateKey] for a date heirarchy listing. My goal is to determine a few things,   If Due Date is less than Today() = ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I think I have finally figured out a solution, what I ended up doing was creating an IF measure which determined if my receive date was greater than my ship date it would return "1". After which I then created new IF measures for each of my values which referenced my shipping measure and if a 1 was present it would be blank, otherwise it would display it's data.

    The matrix visual seems intelligent enough to then omit those blank rows thus not displaying unwanted data. 

    Thank you all for your help, I couldn't of got here without you.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks vanessafvg 

Anytips on how I could also filter out that which is beyond the due date?

Essentially this


If Due Date is greater than Due Date = 'Not Due'

I have been racking my brain looking for a solution, but with no anchor point to compare I am a bit lost.

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

Anonymous i am a bit confused how can it be > than itsself, or is it 2 different fields?  what defines the due date and how can it be greater than itself.?