Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Looking Solution for COMPLEX SLICER

Good day All,    I'm looking for comple slicer solution. I will try to explain:  I have 5 shops - every shop has audit every 3 month and as the result of the audit every shop generates excel file....
DAX
Slicer
jameszhang0805's avatar
jameszhang0805
Icon for Resolver IV rankResolver IV
5 years ago

Hi Anonymous , once you uploaded the data into PBI, you will see some dates of your excel file in the power query. Maybe you can use them to identify the version of your shop data.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks, I also extract date of particular report from each file content. I can filter them by date. Problem is that some shops have 3 ausits, some only one - frequency is dymanic as well. Latest audot report normally identified by sorce file name:

     

    01-2020 Shop One

    02-2020 Shop Two

    03-2021 Shop One 

     

    So, If I use table, I choose show last in the row and will show me last file in connection to particular shop (DATA Connection established) 

     

    How to filter all content of Report to use only LAST files for every shop - this is remains a task. 

     

    Cheers

    Aleks