Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a data table registered from January to December. When the slicer is in March, I want to return all records from January through March.
How to do this with DAX?
what i found online
i'm guessing that you want a year to date total of some field
The following sample formula creates a measure that calculates the 'year running total' or 'year running sum' for Internet sales.
=TOTALYTD(SUM(InternetSales_USD[SalesAmount_USD]),DateTime[DateKey])
Help when you know. Ask when you don't!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
18 | |
14 | |
14 |