how to return all results until filter date

AnndreyMacedo · ‎10-02-2019

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?

kentyler · ‎10-02-2019

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.

DAXCopy

=TOTALYTD(SUM(InternetSales_USD[SalesAmount_USD]),DateTime[DateKey])

Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!

Join the conversation at We Talk BI find out more about me at Slow BI

how to return all results until filter date

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!