Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help on Meassure

Hi,

Im trying to get this meassure to work. [SO Net] in other years like 2021, or 2022, should only be untill week 8...
I'm not able to 

SO Max Week = 
VAR MaxYear = MAX('DB'[Year])
VAR MaxWeek = CALCULATE( MAX ( 'DB'[Week] ),'DB'[Year] = MaxYear )
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

Only writing values direclty makes it work:

SO Max Week = 
VAR MaxYear = 2022
VAR MaxWeek = 8
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

 

Need Help

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    HI Anonymous 

     

    Try this:

     

    SO Max Week = 
VAR MaxYear = MAX('DB'[Year])
VAR MaxWeek = CALCULATE( MAX ( 'DB'[Week] ), Filter(all('DB'),'DB'[Year] = MaxYear )))
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    If your question is still open, is it possible to provide some of the example data? What do you expect the output to look like, and also pictures to show the following, thanks.

     

    Best Regards