Last accumulated value in DAX

Introduction

In part 2 of the creation of the COVID vaccine tracker, we are going to model the data we imported in part 1 and create the most difficult calculation: The sum of the values from the last date that is not blank.

Table of Contents

 00:00 Intro

00:55 Show the data

02:00 Model the data

03:30 Explain the 3 constrains that we need to take into consideration

06:10 Create the DAX calculation

08:30 Show the different results you can get from this measure

Full Tutorial

Download Sample File

To get the files:
1. Go to Curbal Download Center > Community Downloads
2. Get File #66 -Part2