Forum Discussion
Helper IExpected turnover per month
Super Useran even distribution based on what? Months? Days? Workdays?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper IDear Ibendlin,
Thank you very much for your response and your request for a data model.
I had created a small set of data with Excel to show what I would like to have in PowerBI.
Unfortunately, it appears not to be possible to upload an Excel file. I then tried with a table, but it became more than 20,000 characters. Is there perhaps another way to send it?
The expected turnover is always invoiced on the last day of the month, so the entire monthly turnover can be booked on the ENDOFMONTH. The first month in which the customer will be invoiced is therefore only a part of the entire month.
Hopefully, based on this information, you have a good tip for me on how to tackle this in various steps.
Thank you very much in advance.
Kind regards,
Hans
- lbendlin
Please use the first link in my reply.