March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi there
I'm having trouble with my dax formula to retrieve previous campaign sales data. I have sales volume for the current campaign per below which filters out any sales with tree type as "I". This works perfectly. The slicer on my page refers to 'Winter Sales' which is the current campaign.
Solved! Go to Solution.
Ok not sure what's your issue, hard to say like this, but try:
Hello buddy,
i don't undertsand why did you use a sumx?
Couldn't you just write:
calculate([Product Sales Volume], numberofcampain= selectedvalue(numberofcampain)-1).
Why use filter inside calculate? Also why use sumx?
Also in this formula:
Hi Gabry thanks I'll clean it up. Makes sense
@DanPell , You can update the measure as
Proud to be a Super User! |
|
Hi @bhanu_gautam @Gabry I have also tried the following variation of the formula and I get a blank result (note the Campaign Name slicer on or off doesn't change the result):
Provide the pbix with sample data
Not sure how to share a sample file with all the workplace firewalls etc.
Ok not sure what's your issue, hard to say like this, but try:
Thanks Dino - it didn't quite work but I have managed a workaround many thanks!
Hi @bhanu_gautam I've tried the above and it doesn't seem to work. I'm wondering if the campaign name slicer (which is implicity linked to the Campaign Number) on the page maybe affecting the outcome. I get a "blank" result. The slicer I have is Campaign name being the current Winter Sale which is campaign number 5.
Below is the data that the formula is pulling from. Quantity is on a separate column not shown here. Thanks let me know what else you need
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |