Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I use the following formula to create a column for week number then select don't summarise and i cannot use this column to a card visualisasion
Solved! Go to Solution.
card can't display list,only can display single number. you can display sum, average, max , min, etc. What's the expected output?
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card
Proud to be a Super User!
= WEEKNUM(MAX(BMCalendar[Date]),2)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
card can't display list,only can display single number. you can display sum, average, max , min, etc. What's the expected output?
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card
Proud to be a Super User!
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |