Forum Discussion
Error Fetching Data for this Visual
Keep getting 'error fetching data for this visual when creating a matrix table. but only when i select these two measures i created: this is the dax i created: could anyone help resol...
hi ms4112 ,
try like:
change % =
VAR _2021 =
VAR _2022 =
RETURN DIVIDE(_2022, _2021) - 1
we can't reference a measure in its own definition.
so this is actually a reference to my second measure which is revenue chnage YoY in £
then i did rev change yoy in %
see below:
so ive followed the same formula as solutions, do you think it could be a setting that needs changing i only downloaded/started using PBI yday for an assignment