Forum Discussion
ribs
Helper I
Helper IDAX to compare two Revenue Year columns with RannkX function
Hello, I am trying to build a matrix with the customers column and two revenue columns for current year and previous year respectively and based on the user's input through a slicer on year. It s...
v-pnaroju-msft Thanks for your reply!
I would like to let you know that the issue was resolved. The problem was that I was using the year column that was connected to the sales table. I should use a disconnected column or a table for the slicer.
However, I checked your report. The output seems to be the same issue I was running into when I click on the Year slicer 2024, the Revenue Previous column is blank, but for 2025 it works fine
ribsHelper I
Helper Ibhanu_gautam No luck!😕