I have two tables: 'QTR' and 'ERROR_DATA'. I have been trying to come up with a measure that calculates SUM() on a column from 'ERROR_DATA' for a selected 'QTR' value in a slicer. It also needs to do the same for the previous 3 quarters and then display it in a matrix. For example, if I select '20214' in the slicer, matrix has to display data for 20214,20213,20212,20211.
Below is the sample data:
Everything works fine with my measure unless there is a blank value in one of the previous 3 quarters. Below is the measure:
Solved! Go to Solution.
@sid_ks , if you select one date period and want to display more, you need an independent date table too.
refer my video on that
Hi Amit. Firstly, thanks for the reply!
I went through the video you posted. Looks like I have my QTR table independent of the ERROR_DATA table. The measure I created is supposed to show data for 4 quarters at one time depending on the slicer selection.
Since both my tables are independent of each other, the above measure works as intended when there is data for the 4 quarters. But whenever a quarter has a blank, it is being skipped when the measure is used in a matrix visual. I tried to handle this in my measure using NA, but that seems to populate all existing quarters instead of the 4 needed.
How do I handle such quarters which have a blank value but need to shown while the measure is used within a matrix visual. I hope I coudl get my point across, please let me know if you need additional info.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.