Update My Power BI Table
Budget: $30 – $250 USD
1) Recreate Sales/Forecast tables based on new Data Warehouse table.
2) Remove superfluous tables to keep things clean.
3) Calculate a count of “New Customers” defined as Customers with one or more invoices in the date range selected AND without an invoice in 18 or more months. In short, take the earliest invoice that falls in between the dates selected, and if this is the newest invoice in the past 18 months for that Customers, it is considered a “New Customer”.
4) Calculate a count of Invoices that have the following values: $99, $149, $249, $300, $499
2) Remove superfluous tables to keep things clean.
3) Calculate a count of “New Customers” defined as Customers with one or more invoices in the date range selected AND without an invoice in 18 or more months. In short, take the earliest invoice that falls in between the dates selected, and if this is the newest invoice in the past 18 months for that Customers, it is considered a “New Customer”.
4) Calculate a count of Invoices that have the following values: $99, $149, $249, $300, $499