Forum Discussion
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:
Hi Alltasks_Chris ,
What you need to create is a calculated table not a measure, since the result will return multiple values....
Best Regards
5 Replies
- technolog
Super User
I think that you should use MAX function
ThisWeekDays =VAR TodayNo = WEEKDAY(TODAY(), 3)VAR StartOfWeek = TODAY() - TodayNoVAR weekdays = DATESBETWEEN(MAX('Calendar'[Date]), StartOfWeek, TODAY())RETURN weekdaysThanks but MAX doesn't work in that context the first argument for DATESBETWEEN is the column containing the dates https://docs.microsoft.com/en-us/dax/datesbetween-function-dax
There are no logic errors in my Measure but it returns a table with multiple values instead of one and that's my intention, the end goal I'm going for won't actually use this measure at the moment I'm just trying to physically see the results of my above DAX to ensure it's getting the results I think it should be.
Hi Alltasks_Chris ,
What you need to create is a calculated table not a measure, since the result will return multiple values....
Best Regards
Thankyou, that's exactly what I needed. My DAX isn't doing what I thought it was but this is how I could see what it is doing to continue to troubleshoot - thankyou!
