Forum Discussion

TeamCanada26__'s avatar
TeamCanada26__
Frequent Visitor
4 years ago
Solved

If Statement with a Calculation

I am trying to create a Fiscal calendar that is particular to our company.    I have the transaction year and the transation month, what I am looking to do is to create a new calculated column that...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Please follow below steps 

     

    1. In power query create a new column 

    Transaction Date +1 = Date.AddYears([Transaction date],1)

    2. In visual write below dax

    New Transaction date = if(MONTH('Table'[Transaction date])>8,'Table'[Transaction Date +1],'Table'[Transaction date])

     

    Please confirm if it works..!!

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please follow below steps 

 

1. In power query create a new column 

Transaction Date +1 = Date.AddYears([Transaction date],1)

2. In visual write below dax

New Transaction date = if(MONTH('Table'[Transaction date])>8,'Table'[Transaction Date +1],'Table'[Transaction date])

 

Please confirm if it works..!!