cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

Measure Help

Dears i would need your help for a measure : i have a table with sales by month , i created another table with dates which i linked many to one: than i created a formula to calculate prices ; Price = DIVIDE(sum('Price Evolution'[Amount]),sum('Price Evolution'[Pieces])) Than based on this i created the following: Price Base = CALCULATE([Price],filter('Price Evolution','Price Evolution'[Calender Year_Month]=[Previous Month] Where Previous Month = SELECTEDVALUE('Previous Month'[Previous Month]) so when i select a month from drop down it actively calculates price for that certain period. Than i want to show data by month as in below Pic with interaction broken to the drop down so it shows all months and what i would like is instead of Price by month to show the delta vs the price of the month i selected and PRice of the month. At this point if i use Price - Price Base it gives me 0 for all months Any ideas on this ? Thanks https://ibb.co/xDDkX26
3 REPLIES 3
Super User

@alexbalazsalex , for last month you can try time intelligence with date table

example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

Helper IV

This doesnt work for me as i want the difference not between the last month but the mont i selected.

Lets say i select price of Jan21, so the graph will show Jan21 price as 0 as its jan21-jan21, than we will have Feb21-Jan21, Mar21-Jan21, Apr21-Jan21 etc....

With the part of Jan to be chaned actively .

Thanks

Alex

Super User

@alexbalazsalex , Do you need to slicer to select the month and take diff ?

if yes, then refer, else share some example output

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors