Forum Discussion
Solved
Weekly Gross Profit by project
Hi, I have the following problem, we work with projects, therefore they have a start and an end date. I want to see the profit by week of each project. person XXX starts 10/02/2020 and finishes the...
Hi,
Ideally there should be a 1 row per date and there is a way to do this in the Query Editor. However, this will increase the number of rows in the source data table. If you are OK with using this approach, then share the download link of your PBI file. Also, ensure there is a Calendar table in that file with a column of week number.
Hi, I understand what you mean, one line per transaction, I am not worried about the number of lines. can I generate the rows in the query if I have a start date and an end date to create all the rows in between? that would be the only way as the database does not have one line per day per person.
Hi,
Yes, it can be done. Share data in a format that can be pasted in an MS Excel file.