I have created a walkthrough so that you can use just 6 DAX formula to develop data extracted from your social media accounts into a metrics dashboard like that below, whether that be LinkedIn, Twitter, blog accounts or your own website.
A Youtube video of this walkthrough is linked here. Some of you may have come here after viewing it – thanks, and welcome! I will get down to what you came here for…
6 Key Metric DAX Formula
From the video, you will see that I used six key DAX expressions or formula again and again to create a comprehensive set of metrics to allow you to develop the dashboard. Here they are in order of development.
Total LinkedIn New Followers = SUM(LinkedIn_Data[LinkedIn New Followers])
You can use SUMX in lieu of SUM if you wish here, noting you will need to provide a table and expression in lieu of a column.
Year to Date (YTD)
LinkedIn New Followers YTD = TOTALYTD( [Total LinkedIn New Followers], LinkedIn_Data[Date] )
Latest Month (MTD)
LinkedIn New Followers This Month = Calculate( [Total LinkedIn New Followers], LASTDATE(LinkedIn_Data[Date]) )
LinkedIn Followers Previous Month = Calculate( SUM(LinkedIn_Data[LinkedIn New Followers]) ,PREVIOUSMONTH(LinkedIn_Data[Date] ) )
Month Over Month Difference
LinkedIn Followers Diff MoM = VAR CurrentS = Sum(LinkedIn_Data[LinkedIn New Followers]) VAR PreviousS = [LinkedIn Followers Previous Month] VAR Result = CurrentS - PreviousS Return Result
Month Over Month % Growth
LinkedIn Followers MoM Growth % = Divide( [LinkedIn Followers Diff MoM], [LinkedIn Followers Previous Month] )
Bonus – Last Date
One simple bonus DAX formula that will extract the latest date in your date table. This is useful for title blocks and banners in you reports and dashs, as it will automatically update when you add your monthly data.
Latest Date = LASTDATE( LinkedIn_Data[Date] )
Once I have developed a set of calculations, I like to test them in a matrix to make sure they have the desired outcome. This is what I have done below. You can then be confident that the cards and visuals you create accurately reflect your data set.
Comments and Feedback
If you have any comments, feedback, or requests, please let me know below or leave a comment on my Youtube channel.
You must be logged in to post a comment.