
I want to find the latest value of a dimension in a datasource and use it as a new dimension.
Example, create the column [Latest Division] based on the the first 3 columns below.
Invoice DateSales Rep IDDivisionLatest Division2018 May 21AU1234CommercialIndustrial2018 May 22AU1234CommercialIndustrial2018 May 23AU1234IndustrialIndustrial2018 May 24AU1234IndustrialIndustrial
For example, i would use {FIXED [Sales Rep ID] : MAX([Division]) }
however, this would return [Division] based on alphabetical order and not latest value
Another way I thought of is to use two separate dimension
Last Invoice date
{FIXED [Sales Rep ID] : MAX([Invoice Date]) }
Latest Division
If [Invoice date] = [Last Invoice Date] Then [Division]
However, i would end with with lots of NULL value that if i filter them off, would filter off past entry
3 réponses