Forum Discussion
Two different dates related to the same variable! 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
You have to have two different date dimensions filtering your table, or the same date dim with an active and inactive relationship. Can you post a screenshot of your model?
Here you go. Would you be so kind and explain your solution with more detiles? I'm compleatly new to Power Bi.
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.
- Hi,
I'll try to give you and example:
Project XYZ was created in 2017 (ORE created) and converted into product in 2019 (Convertions Database). Now, when I try to filter convertions dates to show only results from 2019, XYZ won't be included because it was created in 2017. It's odd and I don't know where the mistake lays...
