Forum Discussion
Helper VCreate a custom column containing a variable
Good day
Please assist.
How do I create a column in powerquery with the following DAX?
Kind regards
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!
6 Replies
- mahoneypat
Microsoft Employee
You can try this expression in a custom column, assuming your FinYear column is type date.
= if [FinYear] = Date.From(DateTime.LocalNow()) then "Default Year" else [FinYear]
Pat
- Tlotly
mahoneypat Thank you. I tried the above code but it doesn't work for financial dates since my slicer is based on the financial period. E.g. My Financial dates are from July to June so when I get to 01 July 2021, it will still default to 2021 as the code you sent is comparing to today. I will want that to default to the new financial year which will be 2022.
- Tlotly
Anonymous Thank you. It's complaining about PriorStepName not being recognised.
v-kelly-msftCommunity Support
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!
