Forum Discussion
Solved
Create a custom column containing a variable
Good day Please assist. How do I create a column in powerquery with the following DAX? DefaultYear = if(YEAR(TODAY()) = 'Branch Scores'[FinYear], "DefaultYear" , 'Branch Scores'[FinYear]) ...
Hi Tlotly ,
Create a column as below:
=if [Year]=Date.Year(DateTime.LocalNow()) then "Default Year" else [Year]For my sample .pbix file ,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
PriorStepName should be replaced with YOUR actual prior step name (the name of your previous step.