Calculate a Column Where it Outputs the Sum of the Total Amount for each item WITH date filtter

[mangchaaBI]

Hi All,

Have another query that wish to get your inputs please

I have 2 tables 

1 table is a list of new products ex.
TBL_NewProduct

And have another TBL for the Invoice data

Here's the output that I would want to achieve as an additional column, so basically if the invoicedate is within the DateLaunched and MaxNewProductListed dates then it will be included in the sum of the output

Thanks!

[Anonymous]

Hi @mangchaaBI ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Fowmy]

@mangchaaBI 

Use this meaure:

	VAR __LaunchDate = TBL_NewProduct[DateLaunched]
	VAR __ListedDate = TBL_NewProduct[MaxNewProductListed]
	VAR __Product =  TBL_NewProduct[ItemName]
	RETURN
	CALCULATE(
		SUM(TBL[Total]),
		TBL[InvoiceDate] >= __LaunchDate,
		TBL[InvoiceDate] <= __ListedDate,
		TBL[ItemName] <= __Product	
	)

[mangchaaBI]

hi @Fowmy Thanks for taking the time to answer, just ran into a bump where I can't seem to add the variables into the equation, thanks

[Fowmy]

@mangchaaBI 

Sorry, Please add this code as a calcualted column to your TBL_NewProduct table.

[mangchaaBI]

hi @Fowmy sorry but can't find any code on your last reply, thank you

[Fowmy · Accepted solution]

@mangchaaBI 

Same as my orgianl reply

New Column = 

VAR __LaunchDate = TBL_NewProduct[DateLaunched]
	VAR __ListedDate = TBL_NewProduct[MaxNewProductListed]
	VAR __Product =  TBL_NewProduct[ItemName]
	RETURN
	CALCULATE(
		SUM(TBL[Total]),
		TBL[InvoiceDate] >= __LaunchDate,
		TBL[InvoiceDate] <= __ListedDate,
		TBL[ItemName] <= __Product	
	)

[mangchaaBI]

Thank you I think this is what I need, problem is that I'm getting a low resource error on my pBI desktop app 😅 cant confirm if this is the fix for me, but I'll tag it as the solution for anyone who wants to try