Forum Discussion

Helper I

4 years ago

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...

Need Help

luzsoulez
4 years ago
I solved it with this post
https://natechamberlain.com/2018/08/08/how-to-add-rows-for-dates-between-start-and-end-dates-in-power-bi-date-range-data/#:~:text=You%20can%2C%20however%2C%20%E2%80%9Cexpand,range%20is%20then%20graphed%20appropriately.&text=Click%20the%20%E2%80%9Cdiverging%2Darrow%E2%80%9D,%E2%80%9CExpand%20to%20new%20rows%E2%80%9D.

luzsoulez

Helper I

4 years ago

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.

Ashish_Mathur

Super User

4 years ago

Hi,

Yes, it can be done. Share data in a format that can be pasted in an MS Excel file.

Forum Discussion

Weekly Gross Profit by project

Related content

Weekly Average

Non-Profit Licensing Options

Missing Project Name

Pak Sweet Sales & Profitability Dashboard 2025 – Power BI Project

Renaming a Power BI project file (.pbip)