Forum Discussion
shareezsaleem
Helper III
Helper IIISplit Contract Value based on 30 days calculation
Hi Team, I need a solution on the below issue. I have a table consist of contract reference no., start date, end date and total contract value. I need to visualize the monthly values (my start dat...
amitchandak
Super User
Super Usershareezsaleem , refer if these approaches can help
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2