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'm relatively new to Power Bi and for starting i wanted to do a tutorial. In there they ask you to calculate the total sales and the last year sales, for that they give you the formula:
but both give me the same result. in fact, i tried this
but this two also give me the same value( between this two, not with the firsts ones)
I'm afraid its a mess with the funtion CALCULATE or SAMEPERIODLASTYEAR, but i couldnt get any clue.
BTW, i tried also without result LY Sales = CALCULATE([Total Sales];SAMEPERIODLASTYEAR(DATEADD('Date'[Date];-1;YEAR )))
Any help would be apreciated, thanks
Solved! Go to Solution.
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |