If Condition - Power Query

[JithinPlr]

Hi All,

Can anyone suggest a formula for the below scenario, since im relatively new to Power BI and the formula which i have used is not working. Thanks in Advance

[goncalogeraldes · Accepted solution]

Hello there @JithinPlr , you can add the following step to your query:

#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Age as of Today", each if [Doc Date] <> #date(1900, 1, 1) then Date.From(DateTime.LocalNow()) - [Doc Date] else Date.From(DateTime.LocalNow()) - [Transaction Date])

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[v-jingzhang · Accepted solution]

Hi @JithinPlr 

You can create a custom column with Power Query. 

if [Doc Date] = #date(1900,1,1) then Duration.Days( Date.From(DateTime.LocalNow()) - [Transaction Date] ) else Duration.Days( Date.From(DateTime.LocalNow()) - [Doc Date] )

Or create a calculated column with DAX. 

Age as of Today = INT( IF('Table'[Doc Date] = DATE(1900,1,1), TODAY() - [Transaction Date], TODAY() - [Doc Date]) )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[goncalogeraldes · Accepted solution]

Hello there @JithinPlr , you can add the following step to your query:

#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Age as of Today", each if [Doc Date] <> #date(1900, 1, 1) then Date.From(DateTime.LocalNow()) - [Doc Date] else Date.From(DateTime.LocalNow()) - [Transaction Date])

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes