Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with the following dimensions:
- Year (e.g. 2022)
- Month (e.g. Jan)
- Date (e.g. 01Jan2022)
- ProductType
- ProductCode
- Color
- etc...
When selecting the following dimensions:
- A Year (and optionally a Month and optionally a Date )
- A ProductType or a ProductCode or a Color or any other dimensions
I would like to compute the MAX Date corresponding to the Year/Month/Date selection, regardless of the other selection (productType, ProductCode, Color etc...)
Many thanks
Kind regards
Annick
If you add the following into your set analysis then you will ignore the filters in those fields.
Max({<productType=, ProductCode=, Color=>} Date)
Hello,
Thanks a lot for your quick reply. Unfortunately I have around 50 other dimensions on top of productType, ProductCode and Color that I would need to ignore. Do I have to specify them all in the set analysis?
Many thanks
Kind Regards
Set up an Alternate State in master Items e.g. Date Only
Create your measure Max({Date Only} Date)
Create filters for your year, quarter, month and then apply the state to the filter.
Should control your date independent of other filters applied.
As you can see in this example the max order date is driven off the filter on year for the altered state whilst other objects still display all the order dates.
Thanks a lot for your detailed reply. Unfortunately I do not have access to the Alternate State capability .
Would there be another way to achieve this? Otherwise, I will use your first solution i.e. Max({<productType=, ProductCode=, Color=, Dimension1=, Dimension2=, etc... >} Date)
Thanks a lot
Annick
That's a shame. I think you'll have to go with the first option.