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 |
---|---|
130 | |
53 | |
35 | |
31 | |
30 |
User | Count |
---|---|
158 | |
54 | |
38 | |
28 | |
27 |