Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
The below dax function returns a running total for the sales table I use. I'm able to filter the value by a customer table, but not by the date table I use. My date table has a custom column called Periodnum( values 1–12), and each period is roughly 28 days, but not always.
When I filter by the period, the date in my table updates, but the measure does not update as intended. It shows the total running time since the beginning of my dataset. I think the issue has to do with my variable LastDateWithSales. I replaced the calculate with just the max date, but that does not filter the measure either. My goal is that if I filter to Period 2, the counter starts at 0, and then day 1 would have the sales from day 1, day 2 would have the sales from days 1 and 2, etc.
Solved! Go to Solution.
Solved it! I wasn't including the fiscal year and period in the result variable. Below is the updated code if it helps anyone else out.
Solved it! I wasn't including the fiscal year and period in the result variable. Below is the updated code if it helps anyone else out.
User | Count |
---|---|
83 | |
75 | |
72 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |