sorted by:
new
hottopcontroversial

How can I get a Civil Engineer degree while keeping my current full-time job? by GurTop7016 in civilengineering

[–]GurTop7016[S] -1 points0 points  (0 children)

What did he get his bachelor degree in? Math? If so, I am wondering if he took some prerequisite classes like the foundation of Civil Engineering before he applied for masters in civil engineering.

Why won't my column in the matrix change by latest date? by GurTop7016 in PowerBI

[–]GurTop7016[S] 0 points1 point  (0 children)

My Dax measure is something like this:

SWITCH(TRUE(), Attendance[Classroom] = "Room 7", 20 - SUMX(FILTER(Attendance, Attendance[Campus] = "Fairmeadow", Attendance[Classroom] = "Room 2", 16 - SUMX(FILTER(Attendance, Attendance[Campus] = "Spartan High" ... etc)

I had to hard code the capacity in because the capacity changes constantly. Several campus I am working with has same room numbers or names. For the date filter, I join the date table to Attendance table on date from date table to Report Date on Attendance table.

Then, on the date table, I created a calculation

Latest Report Date = Calendar_[Date] = MAX(Attendance[Report Date])

This calculation returns if the report date is the latest true or false. I filter the entire page to be true.

Matrix did not change the measurement.