Forum Discussion

22LACMT's avatar
22LACMT
Helper III
3 years ago

Dax

 

I need to create a measure will show the overall Rating (not summerized) for each suplier for the previouse month. 

I will be using this measure in a table to show the current month rating (column) next to the previous months rating  ,

 

and then a measure to subtract the two inorder to see what suppliers had ratings that declined from the previous months

 

Please help! 

thank you!

 

sample data 

 

Need Help

2 Replies

  • 22LACMT's avatar
    22LACMT
    Helper III
    3 years ago

    im currently trying to use the lookupvalue funtion 

    Priormonthrating = LOOKUPVALUE(ProviderInfo[Overall Rating],ProviderInfo[1Period Date],PREVIOUSMONTH(max(DATE(pro))
     
    or 
    Priormonthrating1 = filter (all('ProviderInfo'[Overall Rating]), 'ProviderInfo'[1Period Date] = SELECTEDVALUE(ProviderInfo[1Period Date]) )
  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, 22LACMT 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.