Solved: Re: add week number to card

abc_777 · ‎11-23-2021

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

Weeknum = WEEKNUM(BMCalendar[Date],2)

please help me to create a measure os some how i can show week number to card visualisasion

thanks

ryan_mayu · ‎11-23-2021

@abc_777

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

CNENFRNL · ‎11-23-2021

= 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!