Forum Discussion

Lsh0576's avatar
Lsh0576
Frequent Visitor
3 years ago
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 ...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Ensure that you have a Calendar Table with a week number column in your PBI file.  Share the download link of the PBI file.

  • Lsh0576's avatar
    Lsh0576
    Frequent Visitor
    3 years ago

    Hello there! So I got the calendar table built with a column of 'weeks remaining in the year':

    Now I need to know how to incorporate this to build the metric:

     

    Instead of dividing by 2, I need to multiply by fraction of weeks remaining in the year.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      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.