Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TaufikMaggangka
Helper II
Helper II

Generate two tables with filter from another table

Hi Expert,

I have case where I need to generate new table from 2 tables which are Date table and also school table with condition that the result of date that generate only if existed on the start and end date of the academic year table and also student attendance date on the attendance table.

I already create sampel data set here based on my conditions above(Link)

Thank so much

1 REPLY 1
lbendlin
Super User
Super User

I don't understand what you are trying to measure. Attendance outside the academic calendar?

 

See attached for a proposed data model.  Can you indicate the expected outcome?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.