Join two dates from two different tables

[cocoloco79]

Hi there

I hope someone can help me with joining two dates here.

As you can see in the attached screenshot, the graph is showing a total amount of Acres rather then the total weekly amount.

I created a week start date in both tables, which could be seen as a one to one relationship.

Any ideas how I can use one week start date filter to adjust relsuts from two tables?

Reslut in the attached screenshot should be 2.72 instead of 41 acres.

You can download the pbix form here: pbix 

[amitchandak · Accepted solution]

@cocoloco79 , Need a data model to check. Ideally, you should join two tables with a common date table and should have week created filter there.

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

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.

[amitchandak · Accepted solution]

@cocoloco79 , Need a data model to check. Ideally, you should join two tables with a common date table and should have week created filter there.

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

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.

[cocoloco79]

Hi @amitchandak 

I included a pbix which you can download from my google drive. Does it not work?

PREVIEW

[amitchandak · Accepted solution]

@cocoloco79 , done some changes in file, see if that can help