Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Analitika
Post Prodigy
Post Prodigy

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

Hello,

 

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

Analitika_0-1656422122566.png

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?

1 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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
selimovd
Super User
Super User

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

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

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

What about this?

Analitika_0-1656423109852.png

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.