cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors