Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
MS90
Creator
Creator

How to get Current month data in a table from date field

Need to show current month dates in a table ex.                    

Data 

Column A.     Column B 

01 apr 2023.       Ab 

09 may 2023.      Jk

3 March 2023.     Ce 

5 March 2023.      Df 

02 apr 2023.           Eg

06 may 2023.          Gf

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3 Replies
BrunPierre
Partner - Master
Partner - Master

@MS90  Derive the month number in the script.

LOAD *,
Num(Month(Date((Date#(SubField(Capitalize([Column A]),' ',2),'MMM')),'MMM'))) as Month#

Now use this to display current month dates

Only({$<Month#={"$(=Max(Month#))"}>} [Column B])

BrunPierre_0-1680549398221.png

MS90
Creator
Creator
Author

But this need to be shown in dimensions not in measure tab

BrunPierre
Partner - Master
Partner - Master

Aggr(Only({$<Month#={"$(=Max(Month#))"}>} [Column B]), [Column B])