Forum Discussion

bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
10 months ago
Solved

Sum dynamic parameter fields multiple selected parameter

Here is my scenario: I have 2 parameters with the same amount of colums and I need to be able to select from each of the 2 parameters one or more fields that will sum depending on what fields are se...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi bjackson2760 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    I have created sample data . Please refer below snap.

     

     

    Please refer below output snap and attached PBIX file.

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

bjackson2760's avatar
bjackson2760
Icon for Helper I rankHelper I
10 months ago

Also, there is not only 2, there are 12 parameters for 12 months.  I just wanted to grasp the jest of what I was trying to achieve and then use it for all.  Each column from each parameter will be used to compare against the same month's month's data.  User is able to select each month they want to see for comparison from each parameter.  Each parameter is considered to be a file.  I already have that aspect working it is the interchangeable columns I need to get a "VARIANCE:" column for when comparing.

 

It looks to be most likely that this can't happen...