Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using a calculated column in PowerBI to identify whethere a date is older than 3 months from today.
My table is like so:
Date
30 July 2022 |
30 July 2022 |
30 July 2022 |
15 October 2021 |
28 February 2022 |
29 June 2020 |
29 December 2021 |
I am currently doing this manually, by entering the day that is 3 months ago, however I want to automate this so no manual adjustment. I have written as follows:
Solved! Go to Solution.
Hi @GeorgeR1 ,
This is something I would do in Power Query if possible. This will save the end user having to materialise calculated columns in memory at runtime, and I also personally find it much simpler to write.
Something like this in a new custom column should do it:
let
Date.Today = Date.From(DateTime.LocalNow())
in
if [Action Due Date] <= Date.AddMonths(Date.Today, -3) then "Overdue by 3+ Months"
else if [Action Due Date] < Date.Today then "Overdue"
else if Date.EndOfMonth([Action Due Date]) = Date.EndOfMonth(Date.Today) then "Due This Month"
else "Due Later"
Pete
Proud to be a Datanaut!
Hi @GeorgeR1 ,
This is something I would do in Power Query if possible. This will save the end user having to materialise calculated columns in memory at runtime, and I also personally find it much simpler to write.
Something like this in a new custom column should do it:
let
Date.Today = Date.From(DateTime.LocalNow())
in
if [Action Due Date] <= Date.AddMonths(Date.Today, -3) then "Overdue by 3+ Months"
else if [Action Due Date] < Date.Today then "Overdue"
else if Date.EndOfMonth([Action Due Date]) = Date.EndOfMonth(Date.Today) then "Due This Month"
else "Due Later"
Pete
Proud to be a Datanaut!
Brilliant, thank you. This is exactly what I was looking for.