Forum Discussion
Comparing current data with a baseline information which has no raw data source
Hi, I need to compare my current report with a baseline data which do not have raw data. My current report which is in a pivot (matrix) format is as per below. Basically, the ab...
Create a table 'Baseline' in query editor ("Enter Data") with your static baseline info. Columns <Subs_Calc> and <Tat>.
Relate the two tables together using <subs_calc> columns in each table. Then create a measure to calculate the difference.
Hi,
I tried this method before but when I tried to create the measure to calculate the difference, I am unable not to aggregate the column TAT (from baseline data) on the measure. Is there anyway to create a measure withoit having to aggregate the column, because I need the values for TAT(from baseline data) to be as is.