Forum Discussion
Two different dates related to the same variable! Help!
Hello Everyone!
In my databases I have two dates for the same variable. One is related to creating product code (ex. PBP/18/333, PBP/19/333, PBP/20/333) and another one is related to the date when this code was accepted by the customer (separate spreedsheet). I've made a relationship between those codes in both databases. The problem is that when i want to calculate how many codes were accepted in a specific year, codes created in other year are not included into this sum. May I ask for your help?
I will tel you a little tale about bumblebee. You see, scientists have proven that wings of a bumblebee are way to small to lift such big weight ... but the bumblebee doesn't know about that, and flies anyway.
I managed to fix all my issues with my report. I've cross check all databases and I'm sure that numbers shown are correct.
Thank you very much for your advice. I will still want to finish some Power BI coarse as I'm ambisious and stuborn.
Kind regards,
Daniel
9 Replies
Anonymous ,
I am unable to combine the problem description and data model share. Can you explain with an example.
I would have moved created date to the table have code accepted
date create = minx(filter(Product,product[product code]=table[product code]),product[created at]).
Now if you have to keep both with the same date dimension. And use the same filter refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
In case you need to work with two different date ranges: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Modification need as the above one is on the same date in fact.
