Forum Discussion

Benedicts's avatar
Benedicts
Frequent Visitor
7 years ago

Compare two categories

I have a table with sales by agent and  season like this:

agentseasonsales
agent1AI1812
agent2AI1823
agent3AI1832
agent1AI1934
agent2AI1923
agent4AI1945

 

I try to obtain a power bi matrix as:

agentAI18AI19delta
agent1123422
agent223230
agent332 -32
agent4 4545
Total6710235

 

Can i have an help, please?

Thanks

Tutorial Requests

2 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Duplicate the query, 

    Filter so that you only have one season in each query,
    Merge the query on agent,

    Finally create the delta.

     

    Hope this helps!

    • Benedicts's avatar
      Benedicts
      Frequent Visitor
      7 years ago

      sorry but,

      i have a filter, where the user can choose the season and with a lookvalue function i find the last season.

      So i writed two measure to calculate the quantity like this:

       

      QUANTITA' LAST SEASON =
      VAR LASTSEASON = [selected stagione last year]
      RETURN
      CALCULATE(SUM(fatordspedfatt[Quantità Ordinato]);
      ALL(FatOrdSpedFatt[Agent]);
      ALL(fatordspedfatt[Season]);
      fatordspedfatt[Season]= LASTSEASON)

       

       

      The problem is that in the "last season" colum, the value are present only when there is a value in a "quantity season" colum.

      I like use the measure to obtain the goal, it's possible?