Forum Discussion
Solved
Duplicating values for two dates
Hi there, Please I need some urgent help. I am trying to calculate my quantity values where I duplicate a value for friday to reflect on saturday as well. Here is a sample data Data: Date C...
Hi yve214
not sure if I fully understand the requirement. However, please try
Total Qty = VAR CurrentValue = SUM ( TableName[qty] ) VAR PreviousValue = CALCULATE ( SUM ( TableName[qty] ), 'Date'[Date] = MAX ( 'Date'[Date] ) - 1, TableName[Category] = "a" ) RETURN IF ( MAX ( 'Date'[Week Day Name] ) = "Saturday", CurrentValue + PreviousValue, CurrentValue )
Hi yve214
not sure if I fully understand the requirement. However, please try
Total Qty =
VAR CurrentValue =
SUM ( TableName[qty] )
VAR PreviousValue =
CALCULATE (
SUM ( TableName[qty] ),
'Date'[Date]
= MAX ( 'Date'[Date] ) - 1,
TableName[Category] = "a"
)
RETURN
IF (
MAX ( 'Date'[Week Day Name] ) = "Saturday",
CurrentValue + PreviousValue,
CurrentValue
)