Power BI DAX Measure to create a view of Weekly Sales Count
Hi Guys, need help in writing a DAX query to create a Table view in Power BI As you can see above, I have a Table - which has cities and dates with Sales count, I want to create a view with single record per city and sales count of all its occurrences in that week ending on Saturday. So far i have written this ('Data Sheet' is the name of the excel I am reading data from ...) WeeklySalesCount = ADDCOLUMNS( GENERATE( DataSheet, DATESBETWEEN( CALENDAR(MIN(DataSheet[Date]), MAX(DataSheet[Date])), [Date] - WEEKDAY([Date], 2) + 1, [Date] - WEEKDAY([Date], 2) + 7 ) ), "Location", InvIssue[Location], "Sales", InvIssue[Sales] ) but power gives me error saying, it cannot find this column date: Any other idea, as how to create this table using a DAX measure???
