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.

  • fordmichael20's avatar
    fordmichael20
    Frequent Visitor
    9 years ago

    Hi,

     

    CahabaData

     

    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.