Forum Discussion

AlanP514's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago
Solved

Getting Blank date

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 Tabl...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlanP514's avatar
    AlanP514
    4 years ago

    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

     

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago

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.