Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Data in Table is different than in my Excel spreadsheet

The question is self explanatory via this picture: https://imgur.com/a/ppUGkJ9    Why is there a discrepancy?   Excel spreadsheet number of starts: 1,757 (correct) KPI Indicator starts:         ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

You may try to check the sample report here. If it is not your case, please share your sample file.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi. I've figured out the issue.

 

In my current table I'm using the "Date" field, which I've set to "Date Hierarchy" and thus appears as "Year" and "Quarter" in my table. I used this so that I could calculate the % change YoY and QoQ. This results in my numbers not matching my dataset.

 

However, when I add "Year" and "Quarter" from my dataset into my table, the numbers in my table match my dataset and are correct. But then I cannot use the formula to calculate the % change YoY and QoQ.

 

Can I still create a % change formula without having DATEADD? See my above formula.


Hopefully this makes sense.