Forum Discussion

Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper 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
Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper V rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Super User rankSuper 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.