So I have a list of stores that are called upon sales reps. The sales reps do a check of a demonstration unit each time they visit. Is there a way in PowerPivot if the demonstration unit is not operational to count the number of weeks it has not been operational? I have attached an example of what output I am after.
Ideally I would prefer a solution via Powerpivot but am open to any other suggestions.
Any help would be appreciated.example.xlsx
Last edited by adamzee; 04-12-2015 at 07:55 PM.
Will this work for you?
Last edited by ufopilot; 04-13-2015 at 01:51 AM.
Thanks ufopilot, however I got this solution in dax from another source. I have posted this below for anyone interested.
=if(Table1[Demonstration Unit Operational?]="No", CALCULATE(DistinctCOUNT(Table1[Week]),Filter(Table1,[Demonstration Unit Operational?]="No"&&[Store Name]=[Store Name]&&[Week]>EARLIER([Week]))),blank())
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks