Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have the below measures:
Revenue YTD := CALCULATE([Revenue] , DATESYTD('Date'[Date] ,"31/05" ))
Revenue LYTD:=CALCULATE( [Revenue YTD], SAMEPERIODLASTYEAR('Date'[Date]))
The first one works fine, I would like to modify the second... I would like the SAMEPERIODLASTYEAR('Date'[Date])) to work as it is (that is, bringing the dates for last year), but I want that only to affect Revenue and nothing else.
(I have another dimension that is connected to date, and the SAMEPERIODLASTYEAR('Date'[Date)) brings the values from last year in that dimension which I don't want...)
Hi @Anonymous
Just replace Revenu YTD by Revenu
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |