I am trying to create a monthly forecast for a list of clients that have different start and end dates for their spending.
I am able to create a formula that would work in excel, but am learning Power Bi and having troubles converting the formula to something that would work inside Power Bi without adding the formula to excel file. Column A-F are how the raw data is delivered. Columns G-R are columns that i am trying to avoid adding thru a Dax formula
question from:https://stackoverflow.com/questions/65838934/power-bi-forecast-projected-sales-accross-days-months-between-a-date-range