Forum Discussion
Lookup Visual Calculation not working correctly
Hi khenning ,
In order to help you out there is the need to have more context. But the lookup function is not the best option for this type of calculation. Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
I did add a mockup of my data. Did it not show up?
I was trying the lookup but, I agree, that's not the best way.
Basically, I have 18 months worth of data for the columns in my matrix. I need to have a field in a row be equal to the previous month's data in that same field plus other data. And then the same for the next month.
In excel, the formula for month 1 is =C24+D14-D6, then month 2 is =D24+E14-E6, and so on.
Does that help?
Hi khenning ,
The image with the data is there however from the image only we cannot perecívei the data you have, relationship, tables and everything that give context.
For examples do you have a calendar table? Does your different values on rows are categories on a table or actual values on your fact?
If you are able to share a mockup file it would be apprrciated .
I apologize for any confusion. We use an Oracle database and in 1 view that's in the dataset is where all the data is. I also have a date view so that if we need to filter it other ways, but that's not the plan.
The dates are going to be on rolling 21 months, 3 months in the past and 18 months in the future. The dataset is refresh every morning to make sure we have the latest data.
The basic of my ask is this...Is there a way where we can reference a prior month's calculated field and carry it forward to the next month and use it in a calculated field and keep that going on in the future?
