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.
Hi,
I am having this issue. I tried creating this measure but getting error:
mokLY =
IF( HASONEVALUE( PARDAVIMAI[year]) ,CALCULATE ( [moketina_suma],
DATEADD (PARDAVIMAI[SUTP_IRASO_DATA],-1,YEAR ) ) )
When I put this measure in visual, getting this error:
I am getting this error message. So how to resolve this error?
@Analitika , You should always use date table joined with date of your table
mokLY =
IF( HASONEVALUE( date[year]) ,CALCULATE ( [moketina_suma],
DATEADD (date[date],-1,YEAR ) ) )
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
I tried still not working. I also made a relationship between date table and my table. But stil not working.
Hi @Analitika ,
As far as I know, DATEADD() will return a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context. Due to you add a table into measure which should return a single value, you will get an error as above.
mokLY =
IF(
HASONEVALUE( PARDAVIMAI[year]) ,
CALCULATE ([moketina_suma],
DATE(YEAR(MAX(PARDAVIMAI[SUTP_IRASO_DATA]))-1,MONTH(MAX(PARDAVIMAI[SUTP_IRASO_DATA])),DAY(MAX(PARDAVIMAI[SUTP_IRASO_DATA])))
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok. I solved it. Please help me with this issue. I am getting this whenever I publish it in Power BI.
Hi,
I am facing issue when getting wrong measure. I wanted to calculate growth of sales per year. Here is a measure:
mok_ly =
IF( HASONEVALUE('Date1'[Metai]) ,CALCULATE ( [moketina_suma],
DATEADD ('Date1'[Date],-1,YEAR ) ) )
When I put measure in table, I am getting null value.
I have made a relationship between tables Date and Pardavimai. Measure [moketina_suma] is from Pardavimai table.
Here is a relationship:
So how to resolve this issue?
Hi,
I have this issue:
I created a measure but it gives me null value. How to fix it?
Here how looks visual:
It shows null value.
mok_ly =
IF( HASONEVALUE('Date1'[Metai]) ,CALCULATE ( [moketina_suma],
DATEADD ('Date1'[Date],-1,YEAR ) ) )
Relationship between tables.
Here is a measure:
It could be a number of reasons. Please will you try these two test measures. Please put both of them into the visual and post here a screenshot of the result.
Test1 = CALCULATE ( [moketina_suma], DATEADD ('Date1'[Date],-1,YEAR )
Test2 = IF( HASONEVALUE('Date1'[Metai]) , "true", "false" )
Hi,
Having issue with measure:
mok_ly =
IF( HASONEVALUE(PARDAVIMAI[year]) ,CALCULATE ( [moketina_suma],
DATEADD (PARDAVIMAI[SUTP_DATA],-1,YEAR ) ) )
Getting this error:
Full dax formula:
Hi,
I would like to ask why I am getting null values in visual if there is a relationship between Pardavimai and Date table.
Measure looks like this:
mok_ly =
IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketina_suma],
DATEADD ('Date'[Date],-1,YEAR ) ) )
null, even I selected years.
Hi,
I would like to ask why it happens that I am getting null if I connected Pardavimai and Date. But when calculating rate and put it in visual see null column.
third column is null.
Why this happens?
mok_ly =
IF( HASONEVALUE('Date'[Metai]) ,CALCULATE ( [moketina_suma],
DATEADD ('Date'[Date],-1,YEAR ) ) )
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |