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!
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,
Kelly
Did I answer your question? Mark my post as a solution!