Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello,
I would like to ask why I am getting null in rate in percent if I use this measure:
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?
Solved! Go to 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
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
What about this?
Without using Date table, date column is used in same table called Pardavimai.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!