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
shashar11 , as long as these are common column you can able to create a new column in the table from other tables likes
example new column in sales from City table
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
City Name = countx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
You can use additional condition and replace maxx with minx , sumx etc