Forum Discussion

Anonymous's avatar
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...
Need Help
Anonymous's avatar
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's avatar
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's avatar
    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.