Forum Discussion
Solved
DAX Query Help Please!
Hello there! I would like to ask for help with writing a query in DAX. Here is what I am trying to do.. I will be reporting this Resource Capacity' equation on a weekly basis: Number of ...
Hi,
Write this masure to calculated Remaining weeks in year
Remaining weeks in year = calculate(min(Calendar[Weeks until end of year]),datesbetween(calendar[date],date(year(today()),12,31),date(year(today()),12,31)))-calculate(min(Calendar[Weeks until end of year]),datesbetween(calendar[date],today(),today()))+1
Use this measure in the denominator.
I also created a date field in my master table ('Date_Today') so I can link the Master table to the Calendar table by DATE field.