Null percentage when comparing this and last year sales in Power BI

[Analitika]

Hello,

I would like to ask why I am getting null in rate in percent if I use this measure:

mok_ly = 
IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketina_suma],
    DATEADD ('Date'[Date],-1,YEAR ) ) )

moketina suma measure is from other table. Basically is a relationship between Date table and another table. But I am getting null somehow, why and how to fix it?

[selimovd]

Hey @Analitika ,

can you provide some data? Otherwise it's hard to find out why the result is empty.

What is the result of the measure without the "DATEADD"? Did you use a date table in your report or not?

Best regards

Denis

[Analitika]

Yes I am using Date table. But getting null rate somehow.

[v-jayw-msft · Accepted solution]

Hi @Analitika ,

Please try this formula:

mok_ly =
IF (
    HASONEVALUE ( 'Date'[Metai] ),
    CALCULATE (
        [moketina_suma],
        FILTER (
            'table',
            'table'[date] = EDATE ( SELECTEDVALUE ( 'date'[date] ), -12 )
        )
    )
)

Best Regards,

Jay

[Analitika]

What about this?

Without using Date table, date column is used in same table called Pardavimai.