Forum Discussion

dyee4613's avatar
dyee4613
Icon for Helper I rankHelper I
8 years ago

Combining Post Date and Date Worked

Hi.  I have a report that takes financial information (which goes by posted date) and productivity which is done based on date worked.  This will always be 4 days after.     Ex: 1/1/2018 to 1/7/201...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi dyee4613,

 

Your request is not very clear, please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

However please help me clarify somethings, is your information in two different tables (Financial and Productivity) each one with their own date column, or are they in the same column and sharing the date column?

 

Can you also share some sample data and expected result.

 

Regards,

MFelix

 

 

  • dyee4613's avatar
    dyee4613
    Icon for Helper I rankHelper I
    8 years ago

    Table 1: Date Worked, contract, Units

    Table 2: Posted date, contract, amount

     

    I created a table (visual, not backend) that shows the cost per unit which takes the amount from table two and divides it by units.  As posted date and date worked are unique, I have to use two filters one to filter the units and another to filter the amount.  My question is that since both dates have a linear relationship (if I know the date range for date worked, I can tell you the ddate range for posted date) is there a way to combine them into a single filter.  

     

    IE: If I select 1/1/2018 to 1/4/2018 for date worked, it will automatically filter the post-date to 1/5/2018 to 1/9/2018.  Is that clearer?