Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

same period last year missing value

Hello,  I have virtual table that name is main and which created with two table.  I need calculate last year of exact date and ı used sameperiod last year . However, when ı used sameperiod last yea...
General Comment
Need Help
Show and Tell
Tips and Tricks
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Anonymous 

Total Unit Price LY =
 CALCULATE([Total Unit Price],PREVIOUSYEAR('Training Dim Date'[Date]))
 
Total LY =
IF (
    ISBLANK (
        CALCULATE ( [Total Unit Price], PREVIOUSYEAR ( 'Training Dim Date'[Date] ) )
    ),
    0,
    CALCULATE ( [Total Unit Price], PREVIOUSYEAR ( 'Training Dim Date'[Date] ) )
)
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I tired your measure but i does not work neither date nor week in my data 
    I just need a measure that can be dynamic with my week and date column  except sameperiod lastyear measure

    thank for having time with me btw