Forum Discussion
Solved
Dynamic date relationship & Measures for data modelling for a use case
Power BI Data Model Question – Allocating Utility Charges by Service Date I need advice on the best data model for allocating utility charges across calendar months. My utility table has one row pe...
I would distribute the bill's amount across its service dates.
You can split a single row into multiple rows using Power Query but I'd do this with a small dataset as this can be very slow with a large one.
Alternatively, you can use DAX measures and a disconnected dates table to spread the amount calculate its value for a specific period.
Please see the attached pbix.
Thankyou Praful_Potphode , danextian , Ashish_Mathur , ShahRukhSameer for Addressing the issue.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
Regards,
Chaithanya