Forum Discussion
Margreet
Helper II
Helper IIDAX formula
Hi, I got a simple model only a date table and a table with Nr, StartDate, Enddate. The date from datetable is connected to Startdate. In the visualisatie I want to see a 1 in every quarter from...
Hi Margreet,
It seems like a common multiple date fields analysis requirement, you can take look at the following blog start date end date part if it helps:
In addition, you can also try to create a calculated table to expand these date ranges and use it as bridge to mapping raw table records:
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
amitchandak
Super User
Super UserMargreet , I think these blogs can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785