Forum Discussion
Matrix with different calendar filters
Hi, I am new to Power BI and would like to start by creating a dashboard to have a broad overview of our progress in a matrix. In the table below, you see what I would like to create: ...
Hey lbendlin ,
Thanks for the help!
But I see you broke down the values per week. What I really wanted to achieve was a little different... But you think that my idea is impossible to make in Power BI?
Aside from that I was curious about your calculation of "# new clients". Could you explain this to me?
# new clients =
var w = max(Dates[Week])
var a = CALCULATETABLE(values('Sales deals'[Client ID]),Dates[Week]<=w)
var b = CALCULATETABLE(values('Sales deals'[Client ID]),Dates[Week]<w)
return COUNTROWS(except(a,b))
Thanks for the help!
Anton
It's not impossible but it blocks you from using the full power of Power BI.
The measure is following the standard pattern of "never seen before" items. For each week (or whatever period you choose) it lists all items that have been encountered in the past, including the period. The same is done for the past before the period. Then you subtract one list from the other, and the result are items that have first been seen in the chosen period.