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.
I have been browsing the community threads and I just can't seem to find the proper formula that would show PY sales but onlyonly calculating it thru the current date. Meaning if I am looking for YTD PY now, I would like it to display the prior year results from Jan-16 thru May-16. I have tried sameperiodlastyear, but it give the full year versus giving the results thru May-16.
Solved! Go to Solution.
Can you share your pbix file, much easier to assist if I can see the the tables, data and relations.
thanks,
Proud to be a Super User!
Thx for the follow-up. I actually cobbled together the solution from Power BI Community threads just before your reply.
Thx for reaching out to help!
Can you share your pbix file, much easier to assist if I can see the the tables, data and relations.
thanks,
Proud to be a Super User!
Thx for the follow-up. I actually cobbled together the solution from Power BI Community threads just before your reply.
Thx for reaching out to help!
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |