Forum Discussion

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

Null rate in Power BI

Hi,   Getting issue. I wanted to count rate comparison this year last year in sales. But getting null values, no idea why it happens? mok_ly = IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Analitika,

    Perhaps you can try to use the date function to manually define the filter range for calculation.

    mok_ly =
VAR currDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        [moketina_suma],
        FILTER (
            ALLSELECTED ( 'Fact' ),
            'Fact'[Date]
                = DATE ( YEAR ( currDate ) - 1, MONTH ( currDate ), DAY ( currDate ) )
        ),
        VALUES ( 'Date'[Metai] )
    )

    Notice: replace the 'fact' table with the table your 'moketina_suma' formula is calculated.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Analitika,

Perhaps you can try to use the date function to manually define the filter range for calculation.

mok_ly =
VAR currDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        [moketina_suma],
        FILTER (
            ALLSELECTED ( 'Fact' ),
            'Fact'[Date]
                = DATE ( YEAR ( currDate ) - 1, MONTH ( currDate ), DAY ( currDate ) )
        ),
        VALUES ( 'Date'[Metai] )
    )

Notice: replace the 'fact' table with the table your 'moketina_suma' formula is calculated.
Regards,

Xiaoxin Sheng