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 am new in Power BI and DAX, need to compare each year summary with the previous year, tried many examples from the forum, nothing works for me, do not understand why the last year columns are empty.
Tried the folowing measures:
Last Year = CALCULATE(sum(Volume[Volume]), SAMEPERIODLASTYEAR(Dates[Date]))
Last Year 2 = calculate(sum(Volume[Volume]), PREVIOUSYEAR(Dates[Date]))
And the tables structure:
Please help! Thank you!
Solved! Go to Solution.
Try to tweak your measures following below sample. Check more details in the attached file.
lastYear = CALCULATE(SUM(Table1[value]),PREVIOUSYEAR(Dates[Date])) last2Year = CALCULATE([lastYear],PREVIOUSYEAR(Dates[Date]))
Try to tweak your measures following below sample. Check more details in the attached file.
lastYear = CALCULATE(SUM(Table1[value]),PREVIOUSYEAR(Dates[Date])) last2Year = CALCULATE([lastYear],PREVIOUSYEAR(Dates[Date]))
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |