Forum Discussion
Distribute Values on Months between 2 Dates (Data Attached)
Hi all, I'm having trouble creating an efficient way of distributing multiple columns values between two dates. I have the table as above. I need to be able to tell per ID how much of a gi...
Hi Anonymous,
Current power bi not support direct analysis data between multiple date columns, maybe you can consider to expand these date range to new table and create relationship to original table for analytics:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng