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

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

MS90 — Fri, 15 Nov 2024 21:56:06 GMT

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

BrunPierre — Mon, 03 Apr 2023 19:17:17 GMT

@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])

MS90 — Wed, 05 Apr 2023 07:43:17 GMT

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

BrunPierre — Wed, 05 Apr 2023 08:04:35 GMT

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