Total Pax for the month - calculation in power BI

[ShanShami]

Hello All,
I need to understand how to take a total sum of pax by suming various snapshots of pax numbers for respective month and year.
I am receiving data on daily basis for pax for a month - which I named as Days B4 Dep.
So I receive data, Days B4 Dep for a month, i want to take a sum of all these Days B4 Dep and show a Pax total in power BI.

Attached excel!

 

[GraH - Guido]

Hi ShanShami,

You may want to look into this article as it explains the pattern.
You are going to need a calendar table in your model.

How to Calculate Cumulative Values with DAX

Scenario: In some scenarios, you may need to do some accumulated calculations such as cumulative sum which is also called running total or multiplication with DAX for subsequent visualizations. And in this article, I will show you several scenarios regarding accumulation and tell you how to...

community.fabric.microsoft.com