Skip to main content

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 respuestas
  1. 4 jun 2018, 8:35 p.m.

    What about This?

    What about This?

    Thanks

    Deepak

    If it Helps, Pl mark it Helpful and CORRECT to close Thread