Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Having issue with sales comparing this year last year in percentage. I created a measure but getting null values somehow.
mok_ly =
IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketina_suma],
DATEADD ('Date'[Date],-1,YEAR ) ) )
Hi @Analitika ,
You may modify your measure as
mok_ly =
IF( HASONEVALUE('Date'[Metai]) ,1,0 )
Then put it in your visual and see if it returns 1 or 0.
And also add a measure as folllows into the visual to check if it returns the results.
CALCULATE ( [moketina_suma],
DATEADD ('Date'[Date],-1,YEAR ) )
The above two actions might help you see which part is going wrong.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @Analitika ,
did you mark you date table as date table?
Otherwise you have to add an ALL('Date') to the CALCULATE.
Did you check if HASONEVALUE('Date'[Metai]) is true? So if the CALCULATE will be executed?
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Yes,
Date table is used in that measure. Date[Metai] means Date[Year], I see is true
Metai is one value.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |