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 currently using below expression for YTD Sales. The reason i used Max here is user can slice based on Year selection dynamically
Try this:
Same Period Last Year = CALCULATE([YTD measure], PARALLELPERIOD('Report - New Cut In'[Date], -12,MONTH))
This works if no year selected from slicer. But if we select year, it is blank. The reason is we are using Max in YTD Measure
Hi @satishkurra
It seems you may change the formula with Link[Fiscal Year]=[vMaxYear]-1 to get last year.Here is the similar post for your reference.If it is not your case,sample data and expected output will be helpful to provide an accurate solution.Please share the .pbix file.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |