Forum Discussion

-Rahul-'s avatar
-Rahul-
Regular Visitor
2 years ago
Solved

Use variable dates in a measure

I need to create a measure with variable dates that I can change using a page-level filter.  Is there any way to this with PowerBI?   This is my measure:       CurrentStudentsOnly = IF ( ...
  • lbendlin's avatar
    2 years ago

    no need to reinvent the wheel.  Your slicers/filters already can do the work for you.

     

    Your data model is missing a calendar table to feed your slicers.

     

    You should merge the Guest Students information into the All Students table, with a "Guest"  flag.