Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Existing data vs corresponding previous data comparison

Hi,   I am currently working with insurance data where policy gets renewed or new policy is placed. I want to achieve something like this:- There is a policy ABC-2021 which gets renewed and policy...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    It's much simpler.

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

It's much simpler.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    I think I complicated it unnecessarily. It was pretty simple.

     

    Thanks.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    It worked well when I didn't use the filter function.

    I tried using this dax with filter function, it gave me blank values.

    last_year_value =
    var prev_policy = MAX(Sheet1[Previous policy no])
    var ly_value = CALCULATE(SUM(Sheet1[Amount]),FILTER(Sheet1, Sheet1[Policy no] = prev_policy))      
    return
    ly_value
     
    Any idea why it gives blank values. As I have to apply multiple filters in my formula, this isn't working in my original work.
     
    Regards,
    Amit