Forum Discussion
Preetsingh86
2 years agoRegular Visitor
Calculate sales value based on specific date
Hi Guys I have been asked to calculate losses before and after date column. Starting the calculation from Financial year start which is 01.09.2023 until the date column and then seperate measure ...
Rupak_bi
Super User
2 years agohi Preetsingh86
You may try this
loss Before=
Var min_date = calculate(min(table,date),all(table))
Var to_date = max(table,date)
return
calculate(sum(table,loss),all(table),table,date>=min_date&&table,date<=to_date)
Same way you can make the after loss as well.
If this doesnot work, please share sample data.