Forum Discussion
General Table and Column Creation Using Different Dates
I am going to ask my question not in terms of Power BI features but in regard to the data set that you are starting with - in that I've written database applications in this type finance in the past;
- I see the top table with 3 fields; date, NAV, multiple Portfolios
- I see the bottom table with 5 fields has a Date, Trans type, and a Cash Amount, single Fund.
So my question is in terms of your dataset: are these two tables directly related by a common transaction ID (not just a generic transaction type ID)? i.e. each transaction (lower table) results in a new NAV (upper table). This would be a 1:1 relationship.
Hi,
I've taken a new strategy for this, I'm using the dates from the transaction table as measures and then using them in my column. My measures look good in the visual view, I've called them RD1 and RD2. However I'm finding them inconsistent when used in my table. Here is my definition for them, the values get shown as I'd like in the visual view:
However, in the column/table view these never change, they only reference the first and last dates in the table from which they're pulled (RD column). Why doesn't this flow back to the table view (note that I added a column just to show what the measures were as I worked through.