Forum Discussion
Insert rows based on values/calculations from another row
I'm pretty new to Power BI/DAX world and more familiar with Excel/SQL. I've been trying to solve the following problem for a quite while now. Here is the case:
I get the Invoice table with accounts, next invoice date, monthly billing from CRM. I only get the "current data" from the attached invoice-table with only single value for "next invoice date". However I'm willing to calculate the future invoicing based on the monthly billing frequency which can variate. In Excel I can do this just by "Edate" function using the attributes next invoice date and billing frequency and fill it down to get the "predicted data" from this invoice-table.
So my question is, is it possible to add rows based on values/calculations from another row in Power BI? Ideal situation would be that I could predict the billing until the end of this year. I know with DAX I can filter, add columns/tables, but I believe not rows? Or could inserting rows be already done in query editor?
2 Replies
You can use CALCULATETABLE to essentially calculate a new table from existing tables.
I was hoping to get the calculated values also on the same table to use them as values on the same column chart. But only way to add rows is to create a new table?
