Forum Discussion
Suhel_Ansari
Helper V
Helper VPreviuos 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 ...
Tahreem24
Super User
Super User
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_AnsariTahreem24
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
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
The format is Whole Number, i can share the pbi file with sample data if you needed. Thanks