To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I'm trying to build a measure (and eventually an area chart) that captures QTD for a 445 calendar that starts on January 1. I've gone through every community forum and Youtube tutorial I can find and still can't get the results I want. I'm continually getting a static number rather than a running total through the quarter.
Solved! Go to Solution.
this blog post from the sqlbi guys should answer your question
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
this blog post from the sqlbi guys should answer your question
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
Thanks! My issue wasn't so much the DAX... for some reason I wasn't using the MAX.
User | Count |
---|---|
14 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |