Forum Discussion
Having Issues with Table Relationships
christianunr , the reason for that can be
Dates FY do not have all the dates ( need by pending charges)
the date (pending charges) having a time stamp and not visible because of format
Create a date like
date = datevalue([Created date])
and use that in join
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
christianunr , the reason for that can be
Dates FY do not have all the dates ( need by pending charges)
the date (pending charges) having a time stamp and not visible because of format
Create a date like
date = datevalue([Created date])
and use that in join
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4