Forum Discussion
New User - Issue Understanding Data Modeling Regarding Dates
Hello BI wizards, brand new user here again… I am having trouble understanding how exactly I am supposed to get a report working as intended in a project I am working on. In my model, I have one...
I had to take a minute to redact sensitive into, but here is the source file with junk data inserted. As mentioned, each row is a project, then for example Project Budget PLAN is the budget for the entire project, In year Budget PLAN is the planned budget amount for 2024 and the following columns will eventually populate with the actuals data.
Even just starting getting a slicer to show only 2024 data, which is in a column of it's own, there is no date to reference. I can't add a column in that includes year, because each row represents all-time project data, not any given year. I don't know how to go about breaking it out in a way that works.