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!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!