They already have a table of targets by products for each region.
Ordinarily, we could have just created a relationship between the transactions data and the target table and leveraged that with measures to create whatever type of report needed. But as it was a training and they needed to experience all the different ways of doing a particular task, we decided to create a table that will extract all the regions, products by regions and total sales volume present in the sales transaction data.
To achieve that, we used the DAX formula: SUMMARIZE
So here's what the sample data I am going to use look like:
And the new table Formula I'll enter is:
Branch_Product_Sales = SUMMARIZE(
'Pizza Sales Data',
'Pizza Sales Data'[Branch],
'Pizza Sales Data'[Pizza Sold],
"Total Sales Quantity",sum('Pizza Sales Data'[Quantity])
)
You can read up on the official documentation of SUMMARIZE: https://docs.microsoft.com/en-us/dax/summarize-function-dax
In essence, how the syntax works is you put in the table name, the columns you want to pick unique items from (combines across the columns, though, which makes it show all the different products for the different branches repeating branches as many times as necessary to show products in that branch) and you add the aggregation formula to run on a column with the values to do a computation on (indicating the name to give the generated column).
There's a more complex use of SUMMARIZE that involves using ROLLUP and/or ROLLUPGROUP. You can get a sense of what they do by going through the already given documentation link.
Here's a short video to demonstrate the formula: https://youtu.be/X8mqjSQ9gOo
Enjoy!
And to join our Power BI training class, visit https://www.urbizedge.com/powerbi or call 01-6311885 or email team@urbizedge.com
Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. Mason jacob
ReplyDeleteThis whole Power BI training where the participants needed to generate a new table from the sales transaction data, is so impressive to knowing but there are also very featuring and the most reflective University Assignment Writers, are always available in giving you their best services in all over the UAE respectively.
Deletewonderful article. Very interesting to read this article. I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. producthunt
ReplyDeleteblogtalkradio
coub
ali
sketchfab
viki
speakerdeck
magcloud
hearthis
musicbrainz
The approach of using SUMMARIZE to create a comprehensive table from transaction data in Power BI for sales regions, products, Year-Month, and total sales quantity showcases a versatile method beyond standard relationships. It's crucial in training to explore various techniques, enhancing understanding. Moreover, Assignment Master Reviews highlight a similar commitment to excellence in academic assistance, ensuring students receive exceptional help tailored to their needs.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteIf you're looking to enhance your skills in Business Data Analysis and Excel, this upcoming training is a great opportunity to dive deep into these essential tools. Whether you're a student or a professional, mastering Excel and data analysis can boost your efficiency and decision-making abilities. Don’t miss out on this special training to elevate your career or academic projects. For students in Singapore who need extra support with their coursework, assignment help sg services are also available to help you manage your assignments while you focus on learning new skills. Register now and get ahead!
ReplyDeleteVisit:https://myassignmenthelp.com/sg/
Registering for the next special Business Data Analysis and In-depth Excel Training is an excellent opportunity for professionals looking to enhance their data management skills. Excel is a powerful tool for analyzing data and making informed business decisions. This training will not only provide hands-on experience with advanced Excel functions but also cover essential data analysis techniques that can significantly improve your productivity. Additionally, mastering these skills can complement your research writing help, as effective data presentation is crucial in delivering impactful reports. Don’t miss out on this chance to elevate your career and sharpen your analytical abilities!
ReplyDeleteVisit:https://myassignmenthelp.com/research-writing.html
Finding the right academic support can be tough, but New Assignment Help made it so easy! I used their Online Assignment Help Australia service for an SPSS research project, and the outcome was fantastic. The expert team broke down complex data analysis steps into simple, understandable parts. Their SPSS Assignment Help exceeded my expectations in terms of quality and timeliness. I highly recommend their services to anyone who wants to succeed in academics without unnecessary stress.
ReplyDeleteI really like your writing style, keep it up, and keep sharing such wonderful articles and blogs. Have you even acquired assignment writing services from an online source? Recently, when I was unable to complete my assignment, so my friend suggested me to buy assignments from Global Assignment Help and I found it really helpful as they made it properly customized as per my requirements as many times as I asked them to do. Recently, I read a blog regarding commentary essay and found it really helpful.
ReplyDelete