Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.