How to do Month to date calculation ?

[bourne2000]

Hi

I am having date table and man power table. Below is the manpower table snapshot

The table has weekly dates (Week ending column)

My date table as below

I would t calculate the month to date calculation for column called GF (Typical Manpower) in the man power table

I used the below dax formula, but it's not working

GF MTD = TOTALMTD(SUM(MAN Power([GF (Typical Manpower)), dates('date'))

The above formula is not working. My date and man power table connect through date and week ending. Can anyone advise how to calculate the MTD calculation?

Here is the sample fil https://we.tl/t-VzCYTQhWl2

[v-janeyg-msft]

Hi, @bourne2000 

Is your problem solved?

If not, I agree with @AlexisOlson What result do you want? It’s not clear in the sample file, we don’t know what you want.

Best Regards,

Community Support Team _ Janey

[bourne2000]

Hi

I am having date table and man power table. Below is the manpower table snapshot

The table has weekly dates (Week ending column)

My date table as below

I would t calculate the month to date calculation for column called GF (Typical Manpower) in the man power table

I used the below dax formula, but it's not working

GF MTD = TOTALMTD(SUM(MAN Power([GF (Typical Manpower)), dates('date'))

The above formula is not working. My date and man power table connect through date and week ending. Can anyone advise how to calculate the MTD calculation?

Here is the sample fil https://we.tl/t-VzCYTQhWl2

[AlexisOlson · Accepted solution]

What are you expecting to get?

This is what I get if I correct the typos in your measure:

GF MTD = TOTALMTD( SUM ( ManPower[GF (Typical Manpower)] ), 'Date'[Date] )

[amitchandak]

@bourne2000 , Th formula seems correct. Make sure your dates table is marked as date tbale.

As your table is having a week end date.  The data will group in win the month having week end date.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bourne2000]

Thanks @amitchandak  Here is the sample pbix file https://we.tl/t-VzCYTQhWl2

I marked the date table into date table but no success