Forum Discussion

gusdahu's avatar
gusdahu
Icon for Helper IV rankHelper IV
7 years ago

Troubleshoot: Folder being used as the data source

Power BI Community,   I created a dashboard with data sourced from a folder located on a shared drive. The folder within the shared drive contains multiple excel documents. Each document represents...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi gusdahu,

 

You can create a custom monthnum column and sort the MonthYear(custom column eg. Jan-18, Feb-18,...... ,Jan-19).

While creating the custom monthnum column you can create it using SWITCH function in dax and give Feb-18 as 1, Mar-18 as 2.....

 

Workaround this, Hope once you will do , you will get clear picture.

 

Thanks,
Amit

  • gusdahu's avatar
    gusdahu
    Icon for Helper IV rankHelper IV
    7 years ago

    Hi Amit,

     

    Would it be possible for me to correct this issue without using a custom column? I say this because I want to be able to run the population out of my ERP system and drop it in the folder with little or minimal changes made to the actual file.

     

    Regards,

    Gus Dahu