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'm sure this will be straight forward, can someone tell me to add a start date to a SUM or SUMX measure please? I'm calculating total sales from 1st August 2023. I can find 'dates between' but not with just a start from.
My date table is 'Dates FY'
Many thanks in advance.
Solved! Go to Solution.
CALCULATE( SUM( 'Sales'[Column name]), 'sales'[date column] >= 01/08/2023)
I've found this isn't filtering my dates, is there anything else it might be?
Is your actual closed date data in date format?
Yes it is
CALCULATE( SUM( 'Sales'[Column name]), 'sales'[date column] >= 01/08/2023)
Thanks Alex, that's great.
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 |
---|---|
104 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |