Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.