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,
I am a beginner, I wish to compare actual vs budget sales but can't get it to work. My actual and budget numbers are both in the same table, along with the regions (one large excel sheet), could this be the problem ?
Here is my table
My selections are :
Thank you for your help !
Solved! Go to Solution.
@debutant , Having them in one sheet is not a problem. Not if there is a column type (Actual/budget) and Value. then you need measures
Actual= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Actual"))
Budget= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Budget"))
Create a date table and other dimensions as per need
refer first 5-6 video of the series , I have discussed breaking of a large table
Power BI Tutorial Series for Beginners: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
thank you, this worked perfectly.
I would like to make YTD comparison vs. prior year, I have written this measure but am stuck because it always shows the full year, I don't know how to make it so that it would only show the same period values as Current year sales, not the entire year. (surrent year woul be defined from a slicer)
@debutant , Having them in one sheet is not a problem. Not if there is a column type (Actual/budget) and Value. then you need measures
Actual= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Actual"))
Budget= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Budget"))
Create a date table and other dimensions as per need
refer first 5-6 video of the series , I have discussed breaking of a large table
Power BI Tutorial Series for Beginners: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |