Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to write a logic in power query.
If the Dispatched Year = current year then null else Dispatched Year.
I created a custome column like IF [Dispatched Year] = Date.Year(DateYear.LocalNow()) then null else [Dispatched Year] But it does not work.
Thanks
Note that M is case sensitive and your localnow function was wrong.
if [Dispatched Year] = Date.Year(Date.From(DateTime.LocalNow())) then null else [Dispatched Year]
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
It is returning all nulls even for Dispatched Year 2021