Trying to create a measure that will be used in a table for a report. Basically, Report will have individual dates as row with measures as columns and will be used in mornings to check information from day befoe. The measure I am trying to get specifically would count distinct orders from the day before.
So far the expression I have is:
count(DISTINCT{$<[completed_date.autoCalendar.Date]={"$(=Date(max([completed_date])-1))"}>}([order_id]))
This only shows yesterdays (9/13) order total but, I am trying to get something like:
Date Value
9/14/2018 (Order Count from 9/13/2018)
9/13/2018 (Order Count from 9/12/2018)
9/12/2018 (Order Count from 9/11/2018)... so on
Any example of an expression that would do this? I think my expression is close, just not what I need. Thanks in advance.