Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Divide 2 values filtered by date

Hello,

 

I tried searching around for similar solutions on this forum and other websites, but was unable to find a solution that works for my dashboard.

 

I am attempting to divide two filtered (by month and year) values from the same table. See display below.

As you can see, the values on the left are filtered by the chosen start date by the user while the values on the right are filtered by the chosen end date by the user. 

 

The date filter is located in a separate table from the data but linked to the original data table. The original data table is where the "Portfolio" and "Benchmark" values are stored. This is where I ran into trouble since these values are not measures, so I cannot simply create a third measure to divide one value by the other.

 

The arrows show which value I would like divided by the other. These would create a comparison between the rate of the Portfolio to the Benchmark.

 

Any tips you can recommend are appreciated!

  • Hi Anonymous 

    Thanks for reaching out to us.

    you have to create 2 calendar table, one used in the left slicer, another one used in the right, then make a comparison between the rate of the Portfolio to the Benchmark.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

    Thanks for reaching out to us.

    you have to create 2 calendar table, one used in the left slicer, another one used in the right, then make a comparison between the rate of the Portfolio to the Benchmark.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • Do you have two calendar dimensions ? One for the start date and another for the end date?

    • Anonymous's avatar
      Anonymous
      Not applicable

      No, I only have one date filter table for all dates connect to the data since I use it for other slicers on the dashboard. Will creating an additional two calendar dimensions (start and end) allow me to create a new measure to divide the filtered values?