Add rows in a PBI report automatically

[Anonymous]

Hi,
Do you know how to add rows to a PBI report automaticaaly. I have already used the dax function union and rows and it worked bu manually because i had to enter the data. For now it is not a problem because it wasn't a lot of data but i will probably meet this problem in the future. Do you know how to solve it ?

The picture below is what i have already done.
Thanks 

[Anonymous]

Hi @Anonymous ,

Accodring to my study, now Power BI does not support it. May you can create  an idea here and post this link for us to vote for it.

If I have misunderstood your meaning, please provide more details and your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PaulDBrown]

If there isn't a source, I would probably go down the route of creating the data in a table in Excel and import the data to append to the other table. It will be easier to update/maintain in Excel, and if you store it in OneDrive and connect the Query to the file in OneDrive, it will update automagically once published in the service (about once an hour I think)

[Anonymous]

I don't think it's the good way to do that because we always have the manual part to do in the excel. what i want is to create a forecast in dax for my product. I have applications that each have several phases. There are 6 life phases in our products and for this year there are applications that are not present on all phases. What I want to do with dax is to anticipate these phases by setting a null value for them because they do not exist