Forum Discussion

tangutoori's avatar
tangutoori
Icon for Helper III rankHelper III
2 years ago

Calculate variance dynamically between two dates even part is replaced

Hi Team,   we have a requirment to calculate variance between two dates (slicer to select date1 and date2). Bridge list contains Old index and New index -- which means old index is a Index on Date1...
@need help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
On 2-Feb-23 INDIA|PUNJAB|A9867|3 is replaced as INDIA|PUNJAB|A9898|3

That is not clear from the sample data.  It could equally be replaced by INDIA|PUNJAB|C1234|4.  You will want to remove that ambiguity before proceeding.