Forum Discussion

AntonV's avatar
AntonV
Helper I
4 years ago

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:     ...
lbendlin's avatar
lbendlin
Super User
4 years ago

Here is an initial version of how you should approach this in Power BI. It's a mix of explicit and implicit measures.

 

Don't try to "make it look exactly like Excel"  - that will be a lot of effort for little gain.

 

 

AntonV's avatar
AntonV
Helper I
4 years ago

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
  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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.

    • AntonV's avatar
      AntonV
      Helper I
      4 years ago

      Hey lbendlin ,

       

      Thanks for the help!!