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 ,

 

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.

    • Tahreem24's avatar
      Tahreem24
      Super User
      6 years ago

      Suhel_Ansari ,

       

      Change your Year column whole number to Date format by Selecting year column --> Go to Modelling Tab --> Under Formatting option --> CHange Data type from Text to Date.

      And then use the measure which I have given in previous post.

       

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