Forum Discussion

hackfifi's avatar
hackfifi
Helper V
6 years ago
Solved

Cumulative NULL issue

Hi All - Having this issue with Cumulative Formula. As you can see where there is NO Data for 'A' (Line 18-Oct-19), and hence i made the value =0. But the cumulative calculation is still coming up as...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi hackfifi 

    I make a test as below, please try my method on your side to see if it works.

    Create a measure

    clc2 = IF(ISBLANK([A]),BLANK(),CALCULATE([A],FILTER(ALLSELECTED('date'),'date'[Date]<=MAX('date'[Date]))))

    My other measures

    A = SUMX('Table','Table'[Act Qty]*'Table'[UR - Base Budget])

clc = IF([A]<>BLANK(),CALCULATE([A],FILTER(ALLSELECTED('date'),'date'[Date]<=MAX('date'[Date]))))

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kentyler's avatar
kentyler
Solution Sage
6 years ago

is [To Date Earned] as measure. If so could we see it please.

  • hackfifi's avatar
    hackfifi
    Helper V
    6 years ago

    sorry kentyler - [To Date Earned] is same as Formula [A]. I just renamed that table headers. Apologies for the confusion

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    It looks like you should be using the maxdate variable you set in the beginning inside the CALCULATE statement for the <= comparison , instead of recalculating the max() there.