Forum Discussion

sammy02hk's avatar
sammy02hk
Icon for Helper I rankHelper I
3 years ago
Solved

Matrix table for Last last 4 week

I finally figure it out. Thank you all. LLW Sales = var LookupStart = LOOKUPVALUE(DateMatch[LLW],DateMatch[Date],     SELECTEDVALUE(DateMatch[WkMonday])) var Lookupend = (LOOKUPVALUE(DateMatch[L...
  • sammy02hk's avatar
    sammy02hk
    3 years ago

    O... I finally figure it out. Thank you All.

    LLW Sales =
    var LookupStart = LOOKUPVALUE(DateMatch[LLW],DateMatch[Date],
        SELECTEDVALUE(DateMatch[WkMonday]))
    var Lookupend = (LOOKUPVALUE(DateMatch[LLW],DateMatch[Date],
        SELECTEDVALUE(DateMatch[WkMonday])))+6  
    return
    calculate(SUMX( 'Sales','Sales'[Sales]),
    DATESINPERIOD(DateMatch[Date],LookupStart,7,DAY))



sammy02hk's avatar
sammy02hk
Icon for Helper I rankHelper I
3 years ago

O... I finally figure it out. Thank you All.

LLW Sales =
var LookupStart = LOOKUPVALUE(DateMatch[LLW],DateMatch[Date],
    SELECTEDVALUE(DateMatch[WkMonday]))
var Lookupend = (LOOKUPVALUE(DateMatch[LLW],DateMatch[Date],
    SELECTEDVALUE(DateMatch[WkMonday])))+6  
return
calculate(SUMX( 'Sales','Sales'[Sales]),
DATESINPERIOD(DateMatch[Date],LookupStart,7,DAY))



  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi sammy02hk ,

     

    I am so glad that you could solve your issue by yourself. Please kindly Accept your workaround as the solution. More people will benefit from it. 

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.