Forum Discussion

Alltasks_Chris's avatar
Alltasks_Chris
Frequent Visitor
4 years ago
Solved

Visualise a List or Column style result

Can anyone tell me what this means:    I'm trying to see if a measure I made even works but I can't figure out how to visualize it - here's my measure:   ThisWeekDays =                 ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Alltasks_Chris ,

    What you need to create is a calculated table not a measure, since the result will return multiple values....

    Best Regards

technolog's avatar
technolog
Icon for Super User rankSuper User
4 years ago

I think that you should use MAX function

ThisWeekDays =
            
            VAR TodayNo = WEEKDAY(TODAY(), 3)
            VAR StartOfWeek = TODAY() - TodayNo
            VAR weekdays = DATESBETWEEN(MAX('Calendar'[Date]), StartOfWeek, TODAY())
            
            RETURN weekdays