Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I've been struggling for weeks to convert a complex Excel sheet into a PowerApps and PowerBI solution. While I've easily done the PowerApp bit I'm really struggling with the PowerBI report.
I've created a few very simple screenshots though the actual worksheet is way more complex.
These are the main tables
And this is what I need to produce in PowerBI
It's basically a daily count of students from the first list that are in active placement on that day by placement name.
The excel formula is something like this:
=COUNTIFS(Students_List, $CellOfPlacement, Students_List!StartDateColumn,">="&DayCell, Students_List!EndDateColumn,"<="&DayCell)
I'm struggling to transalte the above into a PowerBI report 😞
Solved! Go to Solution.
@cipriannsft , I think very similar to HR use case
You can avoid join to date table with start and end date if needed
Hi, @cipriannsft
Could you share some dummy data and draw a simple picture to show your expected visual for further discussion?
refer:
Best Regards,
Community Support Team _ Zeon Zheng
@cipriannsft , I think very similar to HR use case
You can avoid join to date table with start and end date if needed
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |