Forum Discussion
Having Issues with Table Relationships
I can't seem to figure out why I can't populate a table visual with columns based on three different tables. Here is the relationship diagram and the columns that are related:
When I go and make the table visual, the Sum of Pending Charge column doesn't have any values?
I'm not sure where in the relationship I'm going wrong.
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
1 Reply
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