Forum Discussion
Measure: Sumif between two different date fields with connected date table - .pbix example attached
I have a data table with three fields: Start Date, End Date, and Value. The data table is connected to a Date Table (and needs to stay connected). I need to create a measure that sums values when the...
HI Anonymous,
You can refer to the following link to use 'crossjoin' functions to generate a new table with detailed records of the date range, then you can simply summarize these records.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
HI Anonymous,
You can refer to the following link to use 'crossjoin' functions to generate a new table with detailed records of the date range, then you can simply summarize these records.
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng