Subs a date with number

[DYY94]

Hello Community, 

I want to do this calculation  : 

• [Maturite] - [MR/365] : 24/11/2025 - 3

Expected Output : 

So i have created new table called Maturite Modifier in order to do this calculation but i had one issue, it give me always number  '1' for all colmun instead the real numbers from [MR/365]. 

[MR/365]:

 

Knowing that [MR/365] It's measure.

- This is the Output i have for now : 

Here a simplified pbix file to understand the issue. 

https://drive.google.com/file/d/1Y2eAmjcVyWDJozOTxEaNFXh3F9ZeNpmu/view?usp=sharing

Thanks. 

[v-luwang-msft]

Hi @DYY94 ,

Is the output field the same as the one you were expecting, seeing as the field types are not the same in your two images

Best Regards

Lucien

[DYY94]

Hi @v-luwang-msft , 

Thanks for your reply ! 

Yes,  the output field the same as i expect, and the fileds type are the same: 

[Maturite] : Date type

[MR/365] : Number Type

You can check the file i shared to understand more the issue. 

https://drive.google.com/file/d/1Y2eAmjcVyWDJozOTxEaNFXh3F9ZeNpmu/view?usp=sharing

PS: i'm really stuck with this probleme in weeks and i couldn't resolve it.  I appreciate your help. 

Thanks.