Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Frequent Visitor

6 years ago

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.

Anonymous
Not applicable
6 years ago
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.
- ppodgorski
  Frequent Visitor
  6 years ago
  You can use SUM. As long as the baseline <subs_calc> value is unique, it will be be a SUM of 1 value.
  - Anonymous
    Not applicable
    6 years ago
    Hi,
    
    When I use SUM, it does not present the numbers correctly either. The Subs_Calc is unique but when i use this formula
    
    TAT Difference = AVERAGE(FBL1N_JULY_WORKING[Invoice_Date_to_Submission_Date_Calc]) - SUM(Sheet1[TAT])
    
    The results is incorrect.
    
    Sheet1 is basicaly the baseline data and Invoice_Date_to_Submission_Date_Calc is "TAT" column from current data.
Anonymous
Not applicable
6 years ago
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.

Related content