Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic calculation for difference between two non-date matrix columns

I have a matrix with region related fields as the column headers.  A slicer for this matrix contains about 40 regional related fields available to populate the matrix columns.  I have instructions on...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Here's a start.  Download my PBI file from here.

    Hope this helps.

SVM75's avatar
SVM75
Regular Visitor
2 years ago

Hi Ashish,

 

I have a list of sale per month per product (example below, in reality, obviosuly several thousands items)

 

ProductMonthRevenues
Product AJan.24               32.90
Product BJan.24               78.61
Product CJan.24               68.56
Product AFeb.24               90.98
Product BFeb.24               65.62
Product CFeb.24               63.92
Product AMar.24               71.93
Product BMar.24               56.19
Product CMar.24               67.02
Product AApr.24               87.79
Product BApr.24               32.28
Product CApr.24               99.93

 

and would like to have in PowerBI the option to select two month and have the difference dynamically be calculated, e.g.

 

 

THanks, SVM

  • SVM75's avatar
    SVM75
    Regular Visitor
    1 year ago

    Hi, maybe a stupid question, but I get an error when goes over several years (e.g. compare Feb'23 with Jun'24). What would I need to change? Thanks

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      1 year ago

      Hi,

      Will you always select only 2 months - whether within or across years?

      • SVM75's avatar
        SVM75
        Regular Visitor
        1 year ago

        Hi, I guess there would be no way to restrict the user from selecting more than 2 dates, but I could add a comment to advise the user to select only 2 dates