DATESMTD in table related to multiple tables only takes me one

[Syndicate_Admin]

Hello team!

I have a problem with the DATESMTD function

I have a report that brings me information from 7 different tables, tables that are already related to each other by two master tables, one that relates all the users of the different tables and a calendar table to be able to filter by dates.

The drawback with the function is that when I add it to the table that collects all the information, it only gives me value in one of the fields and the rest are blank.

The only peculiarity that this field has in which the function does give results is that it comes from a table that has a single user (all tables are transactions of users from different platforms)

Help!!

[amitchandak]

@Syndicate_Admin , All Fact should join with dimensions/master table including date

Date table join should be marked as date table and join should be single directional .

if no date is selected datesmtd uses the last date of date table and that month should have data

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...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.