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!
User | Count |
---|---|
88 | |
33 | |
32 | |
17 | |
13 |
User | Count |
---|---|
93 | |
28 | |
23 | |
16 | |
16 |