Forum Discussion
Solved
Count
Hi all, We have to show the count of customers. In my table I am having Customer ID, Zone Category values are (Retail, F&B, L&E) Count of each unique customer who started in the "Retail" category an...
This will give what is next Zone Category In the same row. Create a new column
minx(filter(table,table[CustomerId] = earlier(table[CustomerId]) && table[session start] > earlier(table[session start])),table[Zone Category])This can be used to calculate.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
HI manideep547 ,
Maybe you can try to use the following measure formula to calculate the category count of a specific customer:
Measure =
VAR currDate =
MAX ( Table[session start] )
RETURN
CALCULATE (
COUNTA ( Table[Zone Category] ),
FILTER ( ALLSELECTED ( Table ), [session start] > currDate ),
VALUES ( Table[CustomerID] )
)
Regards,
Xiaoxin Sheng