Having Issues with Table Relationships

[christianunr]

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.

[amitchandak · Accepted solution]

@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-bd52912a5b...