Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago
Solved

YTD amendment for last Financial Year

Hi,   My code below is now counting the no of incidents in the current FY just started (01/04/2023 - 31/03/2024)   How can amend the code below to give me the DistinctCount for 01/04/2022 - 31/03...
Need Help
Show and Tell
  • EdouardPBI's avatar
    EdouardPBI
    3 years ago

    hello, 

     

    try this : calculate([YTD Closed],datesytd(calendar'date,-1,year))

     

    sincerely

     

EdouardPBI's avatar
EdouardPBI
Frequent Visitor
3 years ago

hello, 

 

try this : calculate([YTD Closed],datesytd(calendar'date,-1,year))

 

sincerely

 

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago

Thanks! much appreciated