Power PIVOT sum quantity with a filter date

Maria GO 1 Reputation point
2022-01-27T15:49:10.607+00:00

I have some filters + a date filter.

So I would like to sum since the begginign of the data till the date selected on the filter (it will be selected just 1 day). For example:

169000-image.png

My filter will be just selected the day 16/01/2022

Wich quantity of that day will be = 74

BUT in reality I want the sum since the beginnig till the day 16/01/2022

169124-image.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,506 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Herbert Seidenberg 1,191 Reputation points
    2022-01-29T17:48:18.783+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.
    Added more features to make it somewhat more interesting.
    With Time Intelligence Functions.
    With Date Table and PivotChart.
    Two period date selections.
    https://www.mediafire.com/file/lagq8qh03gomqsq/01_29_22.xlsx/file
    https://www.mediafire.com/file/15fs9o12f14v98a/01_29_22.pdf/file

    0 comments