If Date is <= today set column to "Actual" otherwise "Budgeted"

[CJKPowerBI]

Hello all,

i have a Transaction Date column and then in Power Bi i created another column named "Actual / Budgeted".

what i would like is to have a formula to the "Actual / Budgeted" column (if possible) and to verify the "Transaction Date"
 with todays date and if is smaller or equal to put "Actual" otherwise to put "Budgeted"

thank you in advance.

[lukiz84]

So you want a calculated column or do you already have it?

Column := IF(Table[Transaction Date] <= TODAY(), "Actual", "Budgeted")

[CJKPowerBI · Accepted solution]

found the solutio....Actual / Budgeted = IF (Today() <= [Transcation Date], "Budgeted", "Actual")