Forum Discussion
build Relationship Problem
Dear Team, I have three different data-sheet in Power Bi and trying to build a relationship based on the date dimension table but facing the below error. scenario When I use each table wk# to crea...
Hi HZAFAR ,
Create a calender table. Build all relationships with this calender table and check.
Use following DAX code to create calender table.
Calender = CALENDAR (DATE (2022, 1, 1), DATE (2023, 12, 31))
Thank you.
This is not working.
secondly i need to create week number and DAX function is not giving me the correct wek day as complared to excel based formula (=ISOWEEKNUM(Date)