Max value per week based on WEEK relationship between tables

[Anonymous]

Hi All,

I want a measure for MAX value per week and further use this measure in a table which does not have a direct active relationship.
Although, week relatiponship exist based on week number.

 

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Check

Column = CALCULATE(MAX('Table'[value]),FILTER('Table','Table'[weeknum]='Table (2)'[weeknum]&&'Table'[product]='Table (2)'[product]))

Best Regards,

Jay 

[amitchandak]

@Anonymous , take week (unsummarized), and these two measure

for product take -lastnonblankvalue(table[value],max(table[product]))

for value take max(Table[Value])

[Anonymous]

@amitchandak @v-jayw-msft

I have attcahed a sample pbix file. Please download.

https://drive.google.com/drive/folders/1E_k7VbgImoTft43JOncSMrwrWtCwVUVx?usp=sharing

I would like to get the MAX value at Item -> week -> MAX(stock_value per item / week ) and the measure Total

For Example : Product_1 -> Week 1 -> 2997

Product_2 -> Week 1-> 316

Measure Total = 3313

Thanks a lot

[pranit828]

Hi @Anonymous 

I would use

calculate(max([value], allexcept(table,table[week_num]))

Did I resolve your issue? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!

Regards,
Pranit