Forum Discussion

Prasad_chattu's avatar
Prasad_chattu
Regular Visitor
1 year ago
Solved

Sameperiodlastyear () issue

Hey everyone , I was trying to check the "last year incidents" through Sameperiodlastyear() dax function. Total Incidents = DISTINCTCOUNT(Reported_Incidents[Incident No]) Last_Year_Inciden...
  • OwenAuger's avatar
    1 year ago

    Hi Prasad_chattu 

    Make sure that the Year column used in the visual is 'Date Table'[Year].

    Based on the measure values in the screenshot, it appears that the Year column may be from Reported_Incidents or another table.

     

    Does that fix it?