Forum Discussion

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
6 years ago
Solved

Dax Soustract DATE

Hello, I need your help guys to achieve a formula.   I have a column that containt "Year-Month" for exp : YearMonth 2019-01 2019-02 2019-03 N..   I have another column that contains number ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi FZOU ,

    Can you change the data type of column "YearMonth" from Text to Date? If yes, maybe you could try this:

    Column =
DATE ( YEAR ( 'Table'[YearMonth] ), MONTH ( 'Table'[YearMonth] ) - 'Table'[MonthN], DAY ( 'Table'[YearMonth] ) )

    And then format the new column as "yyyy-mm".

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi FZOU ,

Can you change the data type of column "YearMonth" from Text to Date? If yes, maybe you could try this:

Column =
DATE ( YEAR ( 'Table'[YearMonth] ), MONTH ( 'Table'[YearMonth] ) - 'Table'[MonthN], DAY ( 'Table'[YearMonth] ) )

And then format the new column as "yyyy-mm".

 

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
6 years ago

v-xuding-msftThank you for your help,it's work perfectly 🙂