***** Related Links ***** Managing Seasonality In Your Budget Analytics - Advanced Power BI blog.enterprisedna.co/managing-seasonality-in-budgeting-analysis-advanced-power-bi/ How To Create Budgets Which Have Seasonality Adjustments - Power BI Technique blog.enterprisedna.co/creating-budgets-with-seasonality-adjustments-automatically/ Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX blog.enterprisedna.co/allocating-detailed-monthly-budgets-or-forecasts-in-power-bi-using-dax/ ***** Related Course Modules ***** Budgeting & Forecasting portal.enterprisedna.co/p/budgeting-and-forecasting Mastering DAX Calculations portal.enterprisedna.co/p/mastering-dax-calculations Power BI Showcases portal.enterprisedna.co/p/power-bi-showcases ***** Related Support Forums ***** Allocating Budget - Granularity? forum.enterprisedna.co/t/allocating-budget-granularity/641 Need To Adjust Credits By Specific Amount Based On What Month Is Listed forum.enterprisedna.co/t/need-to-adjust-credits-by-specific-amount-based-on-what-month-is-listed/1282 Creating Budgets With Seasonality Adjustments Automatically - Power BI Technique forum.enterprisedna.co/t/creating-budgets-with-seasonality-adjustments-automatically-power-bi-technique/502 For more budget allocation queries to review see here….. forum.enterprisedna.co/search?q=budget%20allocation
Hi Sam. Amazing video as usual. How would do if you had different dimension for your budget? ie clients / location / product....? In all your videos you used only one dimension which is the city.Thanks
Hi Sam, I had commented on the relevant video where I need help but didn't get a response. I'm using the below DAX to identify the no of new Customers, can you help me with DAX where I can get the list of who these new Customers are ? New Supplier Count = var SupplierTM = VALUES(PO_Spend[Supplier ID]) var priorsuppliers = CALCULATETABLE(VALUES(PO_Spend[Supplier ID]), FILTER(ALL(PO_Spend), PO_Spend[Ordered Date] > MIN(PO_Spend[Ordered Date]) - [No of Days Value] && PO_Spend[Ordered Date]
HI ---I think Sam did some video similar to what you might be looking for try link below -- hopefully it might help ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.htmlsearch?query=NEW+CUSTOMERS Did you just want a Count of the # of new customers over period of time, or did you actually also want to know who they are --- and maybe how much they bought etc?
@@kevinlabore1726 I have the count and how much they have spent which I got from watching the videos.. Now I'm looking for the list of customers, I want to know who are those new customers. Appreciate your help.
***** Related Links *****
Managing Seasonality In Your Budget Analytics - Advanced Power BI
blog.enterprisedna.co/managing-seasonality-in-budgeting-analysis-advanced-power-bi/
How To Create Budgets Which Have Seasonality Adjustments - Power BI Technique
blog.enterprisedna.co/creating-budgets-with-seasonality-adjustments-automatically/
Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX
blog.enterprisedna.co/allocating-detailed-monthly-budgets-or-forecasts-in-power-bi-using-dax/
***** Related Course Modules *****
Budgeting & Forecasting
portal.enterprisedna.co/p/budgeting-and-forecasting
Mastering DAX Calculations
portal.enterprisedna.co/p/mastering-dax-calculations
Power BI Showcases
portal.enterprisedna.co/p/power-bi-showcases
***** Related Support Forums *****
Allocating Budget - Granularity?
forum.enterprisedna.co/t/allocating-budget-granularity/641
Need To Adjust Credits By Specific Amount Based On What Month Is Listed
forum.enterprisedna.co/t/need-to-adjust-credits-by-specific-amount-based-on-what-month-is-listed/1282
Creating Budgets With Seasonality Adjustments Automatically - Power BI Technique
forum.enterprisedna.co/t/creating-budgets-with-seasonality-adjustments-automatically-power-bi-technique/502
For more budget allocation queries to review see here…..
forum.enterprisedna.co/search?q=budget%20allocation
Hi Sam. Amazing video as usual. How would do if you had different dimension for your budget? ie clients / location / product....? In all your videos you used only one dimension which is the city.Thanks
Hi Sam, I had commented on the relevant video where I need help but didn't get a response.
I'm using the below DAX to identify the no of new Customers, can you help me with DAX where I can get the list of who these new Customers are ?
New Supplier Count =
var SupplierTM = VALUES(PO_Spend[Supplier ID])
var priorsuppliers = CALCULATETABLE(VALUES(PO_Spend[Supplier ID]),
FILTER(ALL(PO_Spend),
PO_Spend[Ordered Date] > MIN(PO_Spend[Ordered Date]) - [No of Days Value] &&
PO_Spend[Ordered Date]
HI ---I think Sam did some video similar to what you might be looking for try link below -- hopefully it might help ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.htmlsearch?query=NEW+CUSTOMERS
Did you just want a Count of the # of new customers over period of time, or did you actually also want to know who they are --- and maybe how much they bought
etc?
@@kevinlabore1726 I have the count and how much they have spent which I got from watching the videos.. Now I'm looking for the list of customers, I want to know who are those new customers.
Appreciate your help.