Subs a date with number

Question

Hello Community,&nbsp;&nbsp;I want to do this calculation&nbsp; :&nbsp;&nbsp;[Maturite] - [MR/365] : 24/11/2025 - 3&nbsp;&nbsp;&nbsp;Expected Output :&nbsp;&nbsp;&nbsp;&nbsp;So i have created new table called&nbsp;Maturite Modifier&nbsp;in order to do this calculation but i had one issue, it give me always number&nbsp; '1' for all colmun instead the real numbers from&nbsp;[MR/365].&nbsp;&nbsp;[MR/365]:&nbsp;Knowing that&nbsp;[MR/365]&nbsp;It's measure.&nbsp;- This is the Output i have for now :&nbsp;&nbsp;Here a&nbsp;simplified&nbsp;pbix file to understand the issue.&nbsp;https://drive.google.com/file/d/1Y2eAmjcVyWDJozOTxEaNFXh3F9ZeNpmu/view?usp=sharing&nbsp;Thanks.&nbsp;

v-luwang-msft · Answer

Hi&nbsp;DYY94&nbsp;,
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
&nbsp;
Best Regards
Lucien

dyy94 · Answer

Hi&nbsp;v-luwang-msft&nbsp;,&nbsp;&nbsp;Thanks for your reply !&nbsp;&nbsp;Yes,&nbsp;&nbsp;the output field the same as i expect, and the fileds type are the same:&nbsp;[Maturite]&nbsp;: Date type[MR/365] : Number Type&nbsp;&nbsp;&nbsp;You can check the file i shared to understand more the issue.&nbsp;https://drive.google.com/file/d/1Y2eAmjcVyWDJozOTxEaNFXh3F9ZeNpmu/view?usp=sharingPS: i'm really stuck with this probleme in weeks and i couldn't resolve it.&nbsp; I appreciate your help.&nbsp;Thanks.&nbsp;

Forum Discussion

Subs a date with number

2 Replies

Related content

Convert Number to Date

Power BI-Waterfall with sub components

Date and number formatting

Dax measure accumulation no Sub / grand total

Change Whole Number to a Date