Forum Discussion
Solved
Create calculated column based on another sheet
Hello - I have a spreadsheet with multiple sheets. Sheets 1 has some data . Sheet 2 has a holiday schedule. I need to upload both sheets to the Power BI and create a calculated column called bas...
Here is the solution I found:
https://community.powerbi.com/t5/Desktop/WORKDAY-formula-in-Power-BI/td-p/202383
The contents of your sheet1 and sheet2 will be transformed into two tables in Power BI.
A "calculated column" in Power BI applies to a row within a table. Usually it won't let you work with two tables especially as they are not related.
What you are probably looking for is a measure. The formula for the measure can take content from multiple tables and will of course depend on your specific requirements.