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
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...
Hi
where are your projects stored (i.e project xyz)?
Anyway, all those bi-directional relationships are dangerous and makes the model difficult to debug. Unfortunately you HAVE TO study how powerbi works, you can't just plug & play, especially where there are several tables connected.
- Hehe, I can see that both of us have nothing better to do on Sundays night than to write comments on power no forum 😉
Convertions, Ore created and other mentioned in the model are being stored in separate spreadsheets. I can't merge them in any way.
I know that I don't know nothing about power bi. I'm willing to learn and I'm doing everything that I can to master this software.
Anyway thank you for your commitment in solving my mystery."Hehe, I can see that both of us have nothing better to do on Sundays night than to write comments on power no forum "
You too 🙂
Anyway, the committment is ok BUT trust me: you CANNOT learn PBI by "starting using it and playing around". I know something like (with different levels, of course) Visual Basic, C, C++, Java, Javascript, Pascal, R, SQL and DAX.
No other language (maybe R, maybe) made me sweat blood like DAX because DAX cannot be learned one piece at a time by playing around and looking at example, forums etc. You *need* to study and really comprehend how it works inside. If you don't do it- the best scenario is that you will fight a lot with it
- the worst scenario is that you make it work and give you a number, but that number will be wrong and you won't be able to understand why, exposing wrong numbers to your stakeholders.
Do yourself a favor. Go to sqlbi.com and run their free course.
- I will do that because I really want to know how to properly use power bi. I'm learning python as well.
Problem is, that I need to generate this mentioned report now and not after a year spent on learning.
May I ask you for your advice on that one?