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,
Request your guidance to solve this issue
We have a dashboard which shows sales for the day and month when we select a salesman from the slicer. We would like to have the sales during the last year on the same date for the selected salesman. i.e if sales of 02/12/2022 is $100 then it should also show sales for the date 02/12/2021. how can we make this happen
kindly advise
regards,
dsmitha
Solved! Go to Solution.
Hi @dsmitha ,
You can use SAMEPERIODLASTYEAR to accomplish this:
https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Please accept as solution if this answers the question- thanks!
Hi @dsmitha ,
You can use SAMEPERIODLASTYEAR to accomplish this:
https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Please accept as solution if this answers the question- thanks!
hi djurecicK2,
Thanks a lot, super simple solution
double kudoz
regards,
dsmitha
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |