Forum Discussion
joshua1990
Post Prodigy
Post ProdigyTranslate Excel Function into Dax
Hello everybody! Is there any chance to migrate these excel functions into DAX (calculated columns)? =DATE($A2,1,1)-WEEKDAY(DATE($A2,1,1),3)+(ISOWEEKNUM(DATE($A2,1,1)-WEEKDAY(DATE($A2,1,1),3))<>1)*...
joshua1990Post Prodigy
Post ProdigyHow can be built that function in Dax?
WEEKDAY(DATE($A2,1,1),3)
I can't use [Year] as $A2.
How would you replicate this?
Greg_Deckler
Community Champion
Community ChampionSo that depends, would need to understand your data layout. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But in general, you obviously can't use cell references with DAX, you have to filter down to the cell that you want using things like LOOKUPVALUE or MAXX(FILTER(...),...)
Things like that.