Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago

Null value using measure in Power BI

Hello,   I would like to ask how to fix this. I wanted to calculate the change between years but getting null value, Formula looks like this: mokLY = IF( HASONEVALUE(PARDAVIMAI[year]) ,CALCULATE...
Need Help
Saap's avatar
Saap
Icon for Resolver III rankResolver III
4 years ago

In SAMEPERIODLASTYEAR function use the date column from your date table instead of PARDAVIMAI[SUTP_DATA].

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi, it also wrong:

 

All time diff is -1. But sum is different in 2021 and 2022 years. I also checked that there is a relationship between date and table2 tables. But getting wrong answer.

 

  • Saap's avatar
    Saap
    Icon for Resolver III rankResolver III
    4 years ago

    Analitika 

    Maybe try to post some sample data and expected result.
    It would be easier to work on.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Expected result that I could percents how sales increased or decresed per period.

      I use formula but it doesn't work.