Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can some one help me with my month Format
In my month Filter i am getting values as per below snapshot
like 43252 but i need everything should be like "201711" format
This is happening because when i source data from different Sources for different KPI's few of the KPI's month is coming like 43252 etc. but i need my month filter with values like 201711 foramt
while loading just add Date(Month) it will convert number to date later you can define format 'YYYY-MM' or YYYYMM
if(len(Month)=6,date(date#(text(Month),'YYYYMM'),'YYYYMM'), DATE(Month,'YYYYMM'))
Please don't duplicate thread.