Forum Discussion

noobtopowerbi's avatar
noobtopowerbi
Frequent Visitor
2 years ago

compare with count previous year

I have a table1 containing customerid, month, presenceboolean. I have a calendartable containing date,month,year. Now I want to visualize a table with columns year, distinctcount customerid and dist...
Need Help
ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hello, 
Based off your description, try the following:

 

Previous Year =
VAR Previous_Y = Year(MAX(DateTable[Date]))-1

Return
CALCULATE(COUNT(Table1[CustomerID]),FILTER(ALL(DateTable),Year(DateTable[Date])=Previous_Y))