Forum Discussion
Date/Time Intelligence Formula
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 the question i am asking though is how will you identify if a due date > than itself, what do you have to compare, what are you comparing it against? you need some sort of indicator, without seeing data or dummy data,its hard to understand how this condition can be crafted
Here is an example set of data, I shrunk the views down for this. Basicially when you drill into an order number it will show an equipment model, then it will show the incoming items for the order. I am wanting to exclude anything that is 'Receiving' after the 'Ship' date.
example.pbix
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.