Forum Discussion

astojanac's avatar
astojanac
Helper II
5 years ago

Dynamic calculated columns based on previous records

Hi everyone,    I need help with one DAX for calculated column.  Down below is example:  I have Date, the First Opening Value and Payment (green fields). All other field depends one of anot...
Need Help
Show and Tell
astojanac's avatar
astojanac
Helper II
5 years ago

Hi v-kelly-msft , 

Thank you much, this is great!!

Now, I'm facing the problem with number of rows... I have 120 date values, excel table I sent you was just a sample.

I cant type as much rows manualy, and second thinkg, perhaps that number can increse.

So what I need is to always take last month and recalculate new one.  Is that possible?

 

Thanks, 

Alex

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  astojanac ,

 

As I said,if you need to do a multiply calculation in a loop,you'd better finish it outside desktop,such as SQL,then back to desktop to do a sum calculation.

Otherwise,it would be a large calculation in desktop as I show you in the last reply.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!