Forum Discussion
ISFILTERED Usage
I have a table structure like below: Company Category FiscalYear Revenue AdW Bikes FY17 200 AdW Cars FY17 99 AdW ...
Hi karun_r
So how do you want the Fiscal Year to affect your expected result? Do you want to ignore it and still generate the same values?
Ideally, I want one value for each fiscal year. So, yes, the fiscal year must be considered when it assigns the range to the company. The end goal is to have a YoY comparison for each revenue range.