Forum Discussion

mglitta's avatar
mglitta
Regular Visitor
5 months ago
Solved

calculate with max() function

Hi,  I try to do simple calc where instead of fixed value i want to use function (max)   formula with fixed value works   REV_CW = VAR REV_CW = CALCULATE(SUM('LOAD'[REVENUE_ACT]), 'LOAD'[...
  • mglitta's avatar
    mglitta
    5 months ago

    just tested my assumption. created a side table with only week numbers from data table. made a max() function on week number and used in calculation and it works fine. simply you cant have calculation and parameter defined from the same table.

mglitta's avatar
mglitta
Regular Visitor
5 months ago

just tested my assumption. created a side table with only week numbers from data table. made a max() function on week number and used in calculation and it works fine. simply you cant have calculation and parameter defined from the same table.

v-ssriganesh's avatar
v-ssriganesh
Community Support
5 months ago

Hello mglitta,
Thanks for the update and for sharing the solution.

It’s good to hear that using a separate table for the week parameter resolved the issue. This will assist other community members in resolving similar issues more efficiently.
Also thanks to Demert for the earlier suggestions.

Best regards,
Ganesh Singamshetty.