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.
Good day
Could you please advise how would you solve pbix task?
I have database with daily prices, I specified date as market year month, market year name
I created the dashboard with monthly average values
I would like to prepare dashboard of below format but
with monthly spread between years to be returned
so in cell 18/19 Jul I want to show the result of 10706 – 10474 = 232 {value}
In excel i would create monthly average table>>added and calculated column Value -12month>> and calculated the difference
How would you advise to do it in Power BI ?
Thank you in advance
Solved! Go to Solution.
thank you all for help
The solution i used eventially is not that elegant but probably it will be helpful for someone
Since the target was to show MoM variation between different years (2018 vs 2017, 2019 vs. 2018, 2020 vs. 2019)
Firstly is created new table
thank you all for help
The solution i used eventially is not that elegant but probably it will be helpful for someone
Since the target was to show MoM variation between different years (2018 vs 2017, 2019 vs. 2018, 2020 vs. 2019)
Firstly is created new table
Hi @InnaBer
>> so in cell 18/19 Jul I want to show the result of 10706 – 10474 = 232 {value}
Are 17/18 & 18/19 measures? If you try measure= [18/19]-[17/18], will it work? If not, could you share the sample file for us to check? Thanks.
Regards,
OliT
Hi @InnaBer
>> so in cell 18/19 Jul I want to show the result of 10706 – 10474 = 232 {value}
Are 17/18 & 18/19 measures? If you try measure= [18/19]-[17/18], will it work? If not, could you share the sample file for us to check? Thanks.
Regards,
OliT
Good day OliT
pls note 17/18 & 18/19 are not measures, it is just matrix table result
pls see sample [download the sample] file attched: i replaced values with random value betweeen 10000 and 15000 to not violate original source rights. The table i look into is [Data]
thank you for you help
Hi @InnaBer
Please try
MyMeasure =
VAR CurrentYear =
MAX ( TbaleName[Year] )
VAR CurrentValue =
SUM ( TbaleName[Value] )
VAR PreviousValue =
CALCULATE (
SUM ( TbaleName[Value] ),
TbaleName[Year] = CurrentYear - 1,
REMOVEFILTERS ( TableName )
)
VAR LastSelectedYear =
CALCULATE ( MAX ( TbaleName[Year] ), ALLSELECTED ( TableName ) )
RETURN
IF ( CurrentYear = LastSelectedYear, CurrentValue - PreviousValue, CurrentValue )
Good day
i will try this solution,thank you
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |