Error: A table of multiple values was supplied where a single value was expected. "RFM_Table = SUMMARIZE(Sales_Data,Sales_Data[CUSTOMER MOBILE],"Recency Value", Measure_Table[Recency_Value],"Frequency Value",Measure_Table[Frequency_Value],"Monetary Value", Measure_Table[Monetay_Value]) could you please suggest 1
According to the speaker, there is an error in the DAX used in Calculating the RFM score. It was written in reverse for the F and M score. This is the right formula: Recency score = SWITCH( TRUE(), [Recency Value]
Error: A table of multiple values was supplied where a single value was expected.
"RFM_Table = SUMMARIZE(Sales_Data,Sales_Data[CUSTOMER MOBILE],"Recency Value", Measure_Table[Recency_Value],"Frequency Value",Measure_Table[Frequency_Value],"Monetary Value", Measure_Table[Monetay_Value])
could you please suggest 1
According to the speaker, there is an error in the DAX used in Calculating the RFM score.
It was written in reverse for the F and M score.
This is the right formula:
Recency score =
SWITCH(
TRUE(),
[Recency Value]
👑👑👑
Can you tell what's the dataset source, it will be easier to follow, can you post a link please
Data quality hmmm not quite well my friend.