Forum Discussion

Suhel_Ansari's avatar
Suhel_Ansari
Helper V
6 years ago
Solved

Previuos Rows Value

Hi DAX Expert, I am struck in a very interesting issue with my DAX measure issue, I have created measures Count of rows which is Count, M_Reg and M_Ter, Running = M_Reg - M_Ter and Last Year, now i ...
Need Help
Tahreem24's avatar
Tahreem24
Super User
6 years ago

Suhel_Ansari ,

 

Give a try to below measure:

 

MEasure = CALCULATE([Running Measure],SAMEPERIODLASTYEAR('Table'[Date]))

 

Or replace SAMEPERIODLASTYEAR with PREVOIUSYEAR().

 

Don't forget to give thumbs up 👍and accept this as a solution if it helped you.

Suhel_Ansari's avatar
Suhel_Ansari
Helper V
6 years ago

Tahreem24 
I don't have Date a column in my table, the year is a columns.. so i can't use the Sameperiod DAX Function in this issue. Thanks

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Suhel_Ansari ,

     

    What is the format of your Year column? or share on same value of your Year column.

     

    Don't forget to give thumbs up 👍and accept this as a solution if it helped you.

    • Suhel_Ansari's avatar
      Suhel_Ansari
      Helper V
      6 years ago

      Tahreem24 

      The format is Whole Number, i can share the pbi file with sample data if you needed. Thanks

      • Tahreem24's avatar
        Tahreem24
        Super User
        6 years ago

        Suhel_Ansari ,

         

        Please share your PBI file by masking confidential data if any.

        Well, Year should be in Date format not a whole number. This is a catch for incorrect result.

         

        Don't forget to give thumbs up 👍and accept this as a solution if it helped you.