
Creator III
2019-03-28
02:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Month Format
Hi,
Can some one help me with my month format.
in my Month Filter values are coming like 43252 but i need all my values should be format like 201711.
issue is with few of the KPI's Month values are Coming like 43252 like that so when i Concatenate all my objects in to a Single fact and my month filter is coming as per below snapshot
5,713 Views
1 Solution
Accepted Solutions

MVP
2019-03-28
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
If( Len(trim(Month))=5, Date(Month, 'YYYYMM'), Date(Date#(Month,'YYYYMM'),'YYYYMM')) as Month
5,664 Views
9 Replies


Master II
2019-03-28
03:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(len(Month)=6,date(date#(text(Month),'YYYYMM'),'YYYYMM'), DATE(Month,'YYYYMM'))
Learning never stops.
5,703 Views


Specialist
2019-03-28
03:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Simply you can use
date(Num(Month),'YYYYMM')
First convert the filed into number and then convert that number format into (YYYYMM) as you mentioned.
5,702 Views

MVP
2019-03-28
03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It depends on how you are getting these values from source. Perhaps try like:
If( Len(trim(Month))=5, Date(Month, 'YYYYMM'), Month) as Month
5,699 Views

Creator III
2019-03-28
04:27 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
It is Coming , but coming as separate line
like 201711 and now changed value 43252 also coming as 201711.
but normally in filters it should show only once right.
It is Coming , but coming as separate line
like 201711 and now changed value 43252 also coming as 201711.
but normally in filters it should show only once right.
5,677 Views

Creator III
2019-03-28
04:29 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Below is the snapshot
you can observe now 43040 is changed to 201711 but if see at the bottom another 2017 11 values is there. it will create confusion to users.
5,674 Views

Creator III
2019-03-28
04:33 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5,669 Views

MVP
2019-03-28
04:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
If( Len(trim(Month))=5, Date(Month, 'YYYYMM'), Date(Date#(Month,'YYYYMM'),'YYYYMM')) as Month
5,665 Views

Creator III
2019-03-28
06:18 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, Still i see 2 lines with same values.
5,651 Views

Creator III
2019-03-28
07:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IT Works.
5,634 Views
