Error in measure in Power BI

[Analitika]

Hello,

I would like to ask how to fix this error in measure:

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

That gives null value even I select one year.

I made relationship with Date table and table2. Table 2 date contains duplicates so that also not helped. So how I can resolve this issue?

[v-henryk-mstf]

Hi @Analitika 

Our engineers have given a relevant solution in a similar thread. Refer to the following link:

Error in measure in Power BI - Microsoft Power BI Community

Best Regards,
Henry

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

[Pbiuserr]

Can you give some sample data?

[Analitika]

mokLY = 
IF( HASONEVALUE(PARDAVIMAI[year]) ,CALCULATE ( [moketina_suma],
    DATEADD (PARDAVIMAI[SUTP_DATA],-1,YEAR ) ) )

Table2 column. 

But still getting null.