Forum Discussion

pamsardinha's avatar
pamsardinha
Frequent Visitor
3 years ago

EOMONTH not returning some values

Hi! I have two measures I created to calculate the difference of Saldo between months.   First one is calculating the saldo of end of month:     SaldoEOM = VAR Latest_Date = MAX('Table1'[Date...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi pamsardinha 

1. Please check if there is data for the date column 5/31 in the "o" type in your table, the current return is empty may have no data for the date column 5/31 last month, or there is no number 5/31 in the date column.

2.You can try the following measure

 

 

SaldoEPM =
CALCULATE (
    SUM ( 'Table1'[Saldo] ),
    FILTER (
        ALLSELECTED ( 'Table1' ),
        'Table1'[Date] = EOMONTH ( MAX ( 'Table1'[Date] ), -1 )
            && [System] IN VALUES ( 'Table2'[System] )
    )
)

 

 

 

Best Regards!

Yolo Zhu

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

 

  • pamsardinha's avatar
    pamsardinha
    Frequent Visitor
    3 years ago

    Hi Anonymous 

     

    Thank you for your reply.

    I tried with your measure and it returns the same error...
    I am sure that there is value at end of 31/5 because I can see in the calculate column SaldoEOM (in my example is 52 for system O).
    If you have any other suggestion, I appreciate.

    Thank you,

    Pamela.