set

Dolly123 — Tue, 10 Jan 2023 04:18:58 GMT

=sum({< FiscalYear=, FiscalMonthName=,
Date={"$(='>='& Date(Monthstart(max(Date),-6)) &'<'&Date(Monthstart(max(Date))))"}
>}[Capacity (TR/HP)])

i want add this formula in set and last 6 month above code

sum({<Stage="won">}capacity)/sum(capacity)

Re: set

vikasmahajan — Mon, 27 Feb 2023 05:29:17 GMT

Hi,

SUM({< Stage = {'won'},Date = {">=$(=Date(AddMonths(Max(Date ),-6),'MMM YYYY'))<=$(=Max(Date ))"} >} [Capacity (TR/HP)])
/
SUM([Capacity (TR/HP)])

Can you try this.

Vikas