Forum Discussion
Add rows and replicate formulas automatically
Hi JDU ,
According to my test, after the data is appended, the calculated column will still be filled.
Please check whether your filter conditions of the calculated column will affect the output of the results after data appended.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
First of all, I'd like to thank you for taking the time to respond.
I'll try to explain better:
1. I have a database from January 2020 which I imported into Power Bi and on which I have multiple dax formulas and calculated columns.
2. Additionally, I have a second Excel database which is from February 2020 and is identical to the January database.
3. What I need to do is add or combine the February data to the January data and have Power Bi automatically perform the same calculations.
4. This is very important for me since I have to add new information every month and I need to have an automated report.
5. On the other hand, I need to have a dashboard with the information of all months in the same report, so the option of having a template is not useful for me since it does not allow me to combine in a single file.
I hope I explained it well!
Hi JDU ,
According to my test, after the data is appended, the calculated column will still be filled.
Please check whether your filter conditions of the calculated column will affect the output of the results after data appended.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.