Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I would like to ask how to fix this. I wanted to calculate the change between years but getting null value, Formula looks like this:
mokLY =
IF( HASONEVALUE(PARDAVIMAI[year]) ,CALCULATE ( [moketina_suma],
DATEADD (PARDAVIMAI[SUTP_DATA],-1,YEAR ) ) )
this formula generates null it is not depending on which year I select.
Hi @Analitika
Maybe try to do something like this:
SumLY = CALCULATE ([moketina_suma], SAMEPERIODLASTYEAR (PARDAVIMAI[SUTP_DATA]))
It is not what I am looking for. My point to get percent to see increase decrese comparing same period. So for this I used:
mokLY =
IF( HASONEVALUE(PARDAVIMAI[year]) ,CALCULATE ( [moketina_suma],
DATEADD (PARDAVIMAI[SUTP_DATA],-1,YEAR ) ) )
@Analitika
You can still use my measure.
Do something like this:
Diff to last year % = DIVIDE ( [moketina_suma], [SumLY],0)-1
This will show you the year over year percentage difference for the period you specify in a slicer.
So if you choose full 2021 year it will show you the difference to full 2020.
Getting this error:
In SAMEPERIODLASTYEAR function use the date column from your date table instead of PARDAVIMAI[SUTP_DATA].
Hi, it also wrong:
All time diff is -1. But sum is different in 2021 and 2022 years. I also checked that there is a relationship between date and table2 tables. But getting wrong answer.
@Analitika
Maybe try to post some sample data and expected result.
It would be easier to work on.
Expected result that I could percents how sales increased or decresed per period.
I use formula but it doesn't work.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
68 | |
64 | |
52 | |
39 | |
26 |
User | Count |
---|---|
80 | |
57 | |
45 | |
44 | |
35 |