Forum Discussion
Value spread over a date range
Hello good afternoon. I'm finding it difficult to find a measure that brings me a value divided over a range of dates, based on just one row in a fact table. I explain: I have the following data:...
Hi,
Actually, it was 13 months, I rectified the date. I didn't quite understand the first solution. As far as I can already extract the month from the date. In addition, there is another rule where if the date is after the 28th of the month, the apportionment will start the following month.
Then you definitely need a custom Calendar/Dates table. It can be maintained externally (for example an Excel file on a sharepoint) and then consumed as a data source in Power BI.
OK, I can't visualize the solution, would you like to exemplify?