Forum Discussion
Fiscal Year Week over Week
I am looking to show the fiscal week over week change. The image below show the current data I am getting with my calculations, but there is an error at the start of a new Fiscal Year. The area I'v...
amitchandak Thank you for the response. I am getting the following error when I use RANKX.
"A single value for column 'FY (num) + FW(num)' in table 'Calendar' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result"
FY(num) + FW(num) calculation results in fields YYYYMM.
My fiscal calendar is a bit more complex... a fiscal year starts on the fourth Saturday of each calendar year.
Hi dogt1225,
Please provide a sample pbix file with some dummy data to test, it should help us clarify your data structures and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng