The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |