current month to 6 month data

[inam]

Hello Everyone 

I Have a column Month1 in this field 

Aug 2023
Sep 2023
Oct 2023
Nov 2023
Dec 2023
Jan 2024
Feb 2024

i want  current month to 6 month data for example current month is Oct-2023 so i want 

Oct 2023
Nov 2023
Dec 2023
Jan 2024
Feb 2024 

Mar-2024(if present in month1 column).

i am using below code but not getting answer.

=Sum({<MONTH1={"$(=Date(AddMonths(Today(),6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])

[Mark_Little]

That would be looking for data 6 months a head. try 

Sum({<MONTH1={"$(>=Date(AddMonths(Today(),-6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])

[inam]

Hello @Mark_Little Thanks For Reply 

i have Tried This also but not getting value .... //Error in Calculated dimension.

[Mark_Little]

Sorry, 

try this

Sum({<MONTH1={">=$(=Date(AddMonths(Today(),-6),'MMM YYYY'))"}>} [Invoiced amount (no VAT)])