Forum Discussion

andi2333's avatar
andi2333
Helper I
2 years ago
Solved

Need help for a simple try otherwise query

Hello, I am pretty new to powerBI and this forum and I am seeking help for a seemingly easy case.

 

I am trying to load data from multiple excel sheets which are all in a folder. Each sheet has multiple tabs with changing names. I only need data from one tab from each file.

 

I was trying to handle this with the following statement, but now I have problems with the syntax for the 2nd error case....basically I am trying to create a nested try-otherwise statement, but I am not sure if such a thing even exists.

 

 

#"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],

 

 

Any help on this is much appreciated.

 

Thanks

 

  • I think you may need another "try": 

    #"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise try Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],

1 Reply

  • I think you may need another "try": 

    #"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise try Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],