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.
Hi,
I would like to write a formula to calculate the total sales for the current year. In my data, I have Year, Weeknumber, productid and sales.
I've used the CALCULATE formula as per below:
Cur Year Sales = CALCULATE(sum('Table'[sales]),'Table'[Year] = MAX('Table'[Year]))
However, the MAX syntax is apparently not allowed in this expression.
Can someone help?
Thanks!
afk
Solved! Go to Solution.
You might need to take the MAX expression out of Filter expression of CALCULATE
Cur Year Sales = VAR maxyear = MAX ( 'Table'[Year] ) RETURN CALCULATE ( SUM ( 'Table'[sales] ), 'Table'[Year] = maxyear )
You might need to take the MAX expression out of Filter expression of CALCULATE
Cur Year Sales = VAR maxyear = MAX ( 'Table'[Year] ) RETURN CALCULATE ( SUM ( 'Table'[sales] ), 'Table'[Year] = maxyear )
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |