Forum Discussion

Khomotjo's avatar
Khomotjo
Icon for Helper II rankHelper II
1 year ago
Solved

Cumulative Measure Returning Errors

Hello Everyone,   I am trying to calculate the  total invoiced MTD for the month of April.  I have used a variable to return the month I want to look at. For some reason this returns  March and Ap...
Need Help
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    Hi Khomotjo ,

     

    Try this :

    Cumulative Invoiced =
VAR period = MONTH(MAX(Movement[EntryDate1]))
RETURN
CALCULATE(
    [Invoiced],
    FILTER(
        ALL(Movement[Date]),
        Movement[Date] <= MAX(Movement[Date]) && MONTH(Movement[Date]) = period
    )
)

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution and a kudos!!

     

    Best Regards,
    Shahariar Hafiz

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

Hi Khomotjo ,

 

Try this :

Cumulative Invoiced =
VAR period = MONTH(MAX(Movement[EntryDate1]))
RETURN
CALCULATE(
    [Invoiced],
    FILTER(
        ALL(Movement[Date]),
        Movement[Date] <= MAX(Movement[Date]) && MONTH(Movement[Date]) = period
    )
)

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz