Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX function to check if record exists in multiple files

Hi everyone! Could you please advise me on below scenario I get 2 source files (Excel) named HeadCount and Terminations every week and I combine latest 6 of each of these files and load them to Powe...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Share sample datasets and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ashish_Mathur Hi, I edited my original post to include link for sample datasets and snapshots of my data for a quick view. 

    Thank you!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

       

      Please download my PBI file from here.

       

      Hope this helps.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ashish_MathurThank you so very much for your efforts. Unfortunately, I am not supposed to use any filters on the week. Is there a way we can get the count without using slicer on the week number?