Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 dates from the Date Table is between the Start Date and the End Date.
Attached is an example .pbix model https://1drv.ms/u/s!AvCirXUmRp-JhcB-nzpsOmkjSpY9yg?e=V8u9Bv
Below is the data table and the resulting visual I'm trying to create using a measure.
Solved! Go to Solution.
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
@Anonymous , refer to my file on a similar topic , attached after signature
Thanks, but in your example the data table is not connected to the date table. I need the data table and the date table connected as I have other visuals that require the two tables to be connected. Is there a way to get this to work if the tables are connected?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |