Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |