Team, I want to extract my date field as Week Name like Week 1 Month name like Jan Quarter Name like Q1 .
When I am trying to use extract function it gives me as a integer number so how can I do that.
My Date column format as YYYY-MM-DD
PFB the details what I am getting
PFB the details what I need
Instead of 2- Week 2, 3- Week 3, 4- Week 4
You can concat the parameter onto the x-axis.
concat(${date_param},‘-’,toString({extract_field}))
For Quaters I would just do an ifelse.
ifelse(${date_param}=‘Quarter’,‘Q’,${date_param}).
Final calculated field would be this.
concat(ifelse(${date_param}=‘Quarter’,‘Q’,${date_param}),‘-’,toString({extract_field}))
Thank You So Much @Max for your help. Every time you help a lot.
Hi @Max , Good Morning
I have to extract Year - MonthName from a date filed like 2024-Jan … 2024_Dec & Year - MonthNumber like 2024-1,2024-2,… 2024-12. are these possible directly with functions available in QS without using concat functions? like in power bi.
Pls a give video link if possible or any article which explains clearly
