I have a parameter, “As Of” as DateTime data type. How can I extract Year (e.g. 2024) and Month (e.g. Feb) from this parameter and display the Year and Month as text?
Sounds simple, but… 
Thanks.
Hi @lbl
you can create a calculated field and use the extract function.
BR
1 Like
Calculated field is created: ThisMonthMMM using formatDate(${paramAsOfDate}, ‘MMM’) instead of extract(‘MM’, ${paramAsOfDate}) which is giving 12, 11, 10 etc.
What visual should I be using as I am unable to find scorecard visual to display the calculated field?
you could use a table
ErikG is correct. have you tried his suggestion. I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!
table can display the calculated field. BUT there is extra space (yellow highlight) in order to display the value in full. Not a neat way. Isn’t there similar feature in Quick Sight as the scorecard visual of Power BI?
