Forum Discussion
Helper IIDAX formula
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
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
MargreetGreat, thank you! I will try working this.
- Margreet
Hello, I tried now this:
Count_active_in_period = CALCULATE(COUNTx(FILTER('Table','Table'[StartDate]<=max(Datetable[Date]) && 'Table'[Enddate]>max(Datetable[Date])),('Table'[nr])),CROSSFILTER('Table'[StartDate],Datetable[Date],None))In 2021_Q2: I want to see 2; this is nr 1 and nr 3 are active in that period.
Hope some know what I can do in the formule, thanks a lot!