In PowerBI, calculate sales variance between the sales on the current date and last known date https://lnkd.in/gnYxS8tn #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Ashish Mathur’s Post
More Relevant Posts
-
In PowerBI, show the highest sale across all Financial years in the total column of a matrix https://lnkd.in/gWnn5CPY #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: Highest ever Sales in Last 5 Years
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, show the budget only till the month of actuals https://lnkd.in/dvpbDCg3 #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: Dynamic YTD Formula (DAX)
community.fabric.microsoft.com
To view or add a comment, sign in
-
DownUnderDAX.com contributor |Microsoft Certified Trainer (Power BI) and Coach | Power BI Consultant | Operations & Team Leader | Stakeholder & Compliance Manager | Technical Product Sales | Process Improvement
A bit behind the 🎱 on this one, but had fun playing with the basic #VisualCalcs today. MOVINGAVERAGE( ) was my favorite Viz Calc so far. What’s yours? New Viz Calcs DAX Sales R12M = MOVINGAVERAGE([Sales Amount],12) So much easier than Measure DAX Sales R12M = VAR NumOfMonths = 12 VAR LastCurrentDate = MAX ( 'Date'[Date] ) VAR Period = DATESINPERIOD ( 'Date'[Date], LastCurrentDate, - NumOfMonths, MONTH ) VAR Result = CALCULATE ( AVERAGEX ( VALUES ( 'Date'[Calendar Year Month] ), [Sales Amount] ), Period ) VAR FirstDateInPeriod = MINX ( Period, 'Date'[Date] ) VAR LastDateWithSales = MAX ( Sales[Order Date] ) RETURN IF ( FirstDateInPeriod <= LastDateWithSales, Result ) https://lnkd.in/gUkGkZ5k #PowerBi #VisualCalculations
MOVINGAVERAGE function (DAX) - DAX
learn.microsoft.com
To view or add a comment, sign in
-
In PowerBI, forecast value based on actual sales of previous periods https://lnkd.in/dqr_swxU #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: referencing a calculated measure value, a row above
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, forecast the monthly sale based on average actual sale in the same month of the 2 previous years https://lnkd.in/dyEEqzpC #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: Sales forecasting for the months in the current year that includes products (using DAX)
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, calculate the YTD revenue and previous year YTD revenue https://lnkd.in/gzG6Ur_Y #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: YTD vs Previous YTD
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, calculate sales of the previous week https://lnkd.in/gzp-7DDh #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: Previous Week DAX
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, count the number of customers whose membership status changed over the previous month https://lnkd.in/dinGpnXS #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: Need Help - Calculating Sales when category is upgraded
community.fabric.microsoft.com
To view or add a comment, sign in
-
In PowerBI, calculated the total sale from customers whose average spend in the past 3 months exceeded 50 https://lnkd.in/gj3cE_Jp #powerbidesktop #powerbi #datamodelling #dax #powerpivot #microsoftexcel #msexcel #excel
Re: I need to count the users whose average sale has been greater than or equal to 50 in past 3 mont
community.fabric.microsoft.com
To view or add a comment, sign in