Find values for BOM of Month

[Rocky6]

Hi All,

i need a set analysis to find BOM of each month. 

For Ex: Currently we are in May, I need to find the value for BOM for april 2023. 

My date field is Month and measure name is Premium. 

* BOM : Beginning of Every month.

Thanks in Advance

[deepanshuSh]

Hi There, 

You can use the following code for getting BOM

Monthstart(Monthname(today())-1)

[Kushal_Chawda]

@Rocky6  considering you have Date field in your data use below expression

=sum({<Date = {"$(=monthstart(addmonths(max(Date),-1)))"}>}Value)

[Rocky6 · Accepted solution]

I have two date fields as i am joining two tables.

Date field is from master table 

Filedate is from Joining table.

So how to add this date fields in the set. 

Thanks in Advance 

[Kushal_Chawda · Accepted solution]

@Rocky6  try below

=sum({<FileDate = {"$(=monthstart(addmonths(max(CalendarDate),-1)))"}>}Value)

[Rocky6]

Thank you its working fine.