Forum Discussion
Accrual Basis Rows splitting
I have connected database to power bi. i need to calculate accrual amount on the basis of start and expiry date of transaction splitted in month column every month. I have a file that does the same i...
To split transaction amounts across months in Power BI based on a start and end date:
- Create a Date Table: Ensure it includes every month within your date range.
- Generate Monthly Values:
- Use DAX to create a calculated column that distributes the amount proportionally across months based on days within each period.
- Set Up Relationship: Link your transaction table to the date table, enabling automatic updates and visuals.
Try this approach, and let me know if it helps!
Chiranjeevi Kudupudi
Power Platform Expert
LinkedIn: Chiranjeevi Kudupudi
If this answer helped, please like it!