Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
found the solutio....Actual / Budgeted = IF (Today() <= [Transcation Date], "Budgeted", "Actual")
So you want a calculated column or do you already have it?
Column := IF(Table[Transaction Date] <= TODAY(), "Actual", "Budgeted")
found the solutio....Actual / Budgeted = IF (Today() <= [Transcation Date], "Budgeted", "Actual")
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |