Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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])
But this need to be shown in dimensions not in measure tab
Aggr(Only({$<Month#={"$(=Max(Month#))"}>} [Column B]), [Column B])