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 |
---|---|
104 | |
31 | |
25 | |
18 | |
15 |
User | Count |
---|---|
101 | |
22 | |
20 | |
18 | |
17 |