Forum Discussion
Guillaume_S
2 years agoFrequent Visitor
Merge two table with two dates
Hi, I want to merge two tables with a calculation. A table has three columns (one column is the contract number, one is the start of the contract and the last is the end of the contract) The seco...
- 2 years ago
Guillaume_S , refer these solutions
Between Dates - Dates between
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
amitchandak
2 years agoSuper User
Guillaume_S , refer these solutions
Between Dates - Dates between
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