Ranking by Business date and day of Week
Hi All! Looking for some assistance. What seems relatively easy is causing me some difficulty. I am looking to rank my sales by different date slicers including the day of week. I have two different tables, one containing my calculated measures derived from other tables and another table containing my dates. When adding in my sales measure and day of week dimension into a matrix, the following formula seems to work somewhat ok if my date slicer is set to week. I say somewhat because it doesn't seem to rank properly, nor does it rank 1 - 7 with one being the highest day. Sales Rank = RANKX(all([BusinessDate]),[CY Sales],,DESC,Dense) When I set my page level slicer to This month it returns all ones. However, if I add dates to the table it then returns some values. But again the ranking doesn't seem to be accurate. What am I doing wrong? Any assistance would be greatly appreciated.
Report for Opportunities closing in 0-30 days, 31-60 days, 61-90 days & > 90 days
Hello Everyone, I just started using Power Bi but I have some experience with it, not as much as id like. I built out a dynamics CRM for sales and I decided to make weekly sales reports in Power Bi rather than SSRS-BIDS SQL reporting. I have created a sample page where I have 3 tables stacked on top of each other. It reads like: Opportunities Closing in the Next 30 Days currently shows all opportunities from today's date with [est. close date] "is in the next" 30 days Opportunities Closing in the Next 60 Days currently shows all opportunities from today's date with [est. close date] "is in the next" 60 days shows duplicates of today- day 30, then new after 31-60 Opportuntites Closing in the Next 90 Days currently shows all opportunities from today's date with [est. close date] "is in the next" 90 days shows duplicates of today- day 60, then new after 61-90 I am using the following fields in each table [Topic] [Account] [Est. Close Date] [Pipeline Phase] [Owner] [Date of Last Activity] [Est Revenue] I want each table to show Opportunities without the duplicates. Sort of like binning data. Im looking to display opportunities closing in (0-30)(31-60)(61-90) days not (0-30)(0-60)(0-90) with three different tables. Where do I start? Do I need to do this with code since the filters in power bi don't give me ability to select [est. close date] after X days and before Y days? It seems like this should be relatively easy. Thank you so much for your help. All the best, Josh
