Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to Solution.
Hi @Alltasks_Chris ,
What you need to create is a calculated table not a measure, since the result will return multiple values....
Best Regards
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!
I think that you should use MAX function
Thanks 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
User | Count |
---|---|
25 | |
11 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |