User Profile
manishbhamare97
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Need help in connecting two table in Power Bi
Hey Power BI community, I need your help for below issue: I have connected below 3 tables (Learning Hours, Daily Planning sheet, Employee 3i Data) with Emp Roll No table to connect employee roll no with other tables. But I want to filter my data by dates between table Daily Planning Sheet and Employee 3i Data, but I'm not able to establish a live connection between those two tables. Is there any other option with which I can filter the data of Table-Employee 3i Data by dates in Table-Daily Planning sheet ?How to refresh the data based on Yesterday's Date
Dear All, I need your help in order to solve the below issue that I'm facing with Power Bi: I have the columns in my data for Date, Plan (Count) , Actual (Count). I want it in a table format where I can show Yesterday's Plan vs Actual count. But during this, I don't want to consider Sundays and other Holidays. Also, the table should get automatically refreshed for yesterday's (working day) Plan vs Actual, I don't want to use manual slicer for that. Date Plan Actual Holiday/Workday Monday, January 1, 2024 5 5 Workday Tuesday, January 2, 2024 4 3 Workday Wednesday, January 3, 2024 Holiday Thursday, January 4, 2024 4 4 Workday Friday, January 5, 2024 3 3 Workday Saturday, January 6, 2024 5 5 Workday Sunday, January 7, 2024 Holiday Monday, January 8, 2024 5 4 Workday Tuesday, January 9, 2024 5 4 Workday Wednesday, January 10, 2024 3 2 Workday Thursday, January 11, 2024 Holiday Friday, January 12, 2024 2 2 Workday Saturday, January 13, 2024 Workday Sunday, January 14, 2024 Holiday Monday, January 15, 2024 Workday
