Forum Discussion
cathoms
5 years agoResponsive Resident
Expression.Error: 1 arguments were passed to a function which expects 0.
I have an Excel workbook called "Dates" and used it to create a table in Power BI called "Date_Lookup". I want to create columns for Fiscal Year, Fiscal Quarter, and Fiscale Period (i.e. sequentially...
- 5 years ago
I was still having problems implementing some of the solutions proposed so I ended up generating the additional fields in excel and just started with a data source that had the fields already. Thanks everyone for trying to help me out. Hopefully after some time I will have a better grasp on Power Query vis-à-vis Power BI and can circle back to implement what you've suggested here.
Cheers!
cathoms
5 years agoResponsive Resident
But then I get the following Expression.Error: We couldn't find an Excel table named 'Dates'.
How do I set or indicate the current workbook?
CNENFRNL
5 years agoCommunity Champion
Attach you workbook pls and I'll show you full steps. I can't make a guess out of anything.