Forum Discussion
Helper ICalculate Opening, Movement and Closing Balances
HI Saes,
According to your description, it seems like a common date range analysis requirement, you can take a look at the following blog (start/end date part) which provided some common scenarios if it helps:
Before You Post, Read This: start, end date
In addition, you can also try to create a expand table to expand the detail date range of records that mapping with raw table row date ranges.
Solved: Spread revenue across period based on start and en... - Microsoft Fabric Community
Regards,Xiaoxin Sheng
HI Saes,
According to your description, it seems like a common date range analysis requirement, you can take a look at the following blog (start/end date part) which provided some common scenarios if it helps:
Before You Post, Read This: start, end date
In addition, you can also try to create a expand table to expand the detail date range of records that mapping with raw table row date ranges.
Solved: Spread revenue across period based on start and en... - Microsoft Fabric Community
Regards,
Xiaoxin Sheng