Forum Discussion

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago

General Table and Column Creation Using Different Dates

Hi, I've asked this before and I am unable to figure this out   I work with portfolio information. I'm bringing in two tables. One is transaction based, with each row having a date to reference a t...
Need Help
Tutorial Requests
CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

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.

 

 

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago

Hey CahabaData

 

First, thanks for the response.

 

Secondly, no, there would be no linkage on transaction ID.

I would be basing this off of the Portfolio code. There is a table in between that has the client, one portfolio per row that I use. See attached.

Essentially I'm just having trouble applying the date filter I want to work on this created table. I've created a non-dynamic view where the date filter has no effect, I want to go to the next step but I'm having trouble.