Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!