Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DATEADD

Hi ,

 

I have a table which contains following columns.

Year

NetRating

Risk Status

Risk Titles

etc

 

I need to show the NetRating of all the Risk Titles which have
A) Risk Status as dropped in current Year

B) Risk Status as Carried over or New in Previous year
C) Risk Status as Dropped in Current Year

 

Could anyone help me with a DAX.

 

Assume that Difference of year can be taken as DATEADD(YearColumn,-1 , Year )

 

Thanks

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    You should create a CALENDAR table to work on it. Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    You should create a CALENDAR table to work on it. Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.