Getting Blank date

[AlanP514]

Hai Guys, I am Facing An issue Please help me. I Have three tables  1. Master Data (All Employees With Distinct records),2.Salary Register Report(Employees Monthly Salary Data)3. Salary Revision Table(This is for specified people who got revised salary )
I was trying to create a line chart for the monthly salary trend. In the Salary Register report, I have data up to April month But I am getting blank for April Data is showing correct only. and I am attaching the existing data model as well please help me.

[Anonymous]

Hi @AlanP514 ,

Glad that your issue was resolved, if possible, please mark your reply as solution, more people will benefit.😁

Best Regards,

Stephen Tao

[PC2790]

Hey @AlanP514 ,

Can you check once if you have dates beyond March 2022 in your calendar table?

Also,Is there any specific reason that the relationship with the Calendar table from Salary Register is inactive?

Thanks 

[AlanP514]

Yes in the calendar table I have data beyond march 2022, Could you help me

[PC2790]

There could be numeeous reasons for this.

1) Could be the relationship, try to make the relationship as active with Calendar to all other tables

2) Check the April data in your Salary Registrar Table,could be that the syntax is not same as that of calendar table.

If you can share your sample file removing sensitive data, I can take a look.

[AlanP514 · Accepted solution]

Now the issue is solved Because my calendar is having more dates but in salary only having up to April so I created a variable from todate and today. now it is working, thank you

[AlanP514]

No Specific reason if I did wrong please correct me. This is the date table and the salary register should connect with employee master data, right? if I connect with master data for the calendar it is showing inactive only but using user relationship I created Dax.