Forum Discussion

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago

LFL Conversion from 2 different tables

Hi,    I am currently working on a formula to update my LFL Conversion.   The problem I am finding is the current formula there is only 1 (Weekly figures) table where I extract the Transactions a...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi alexcatala 

Which column do you want to get from the two tables and how do you want to combine them?

by the way, the syntax of your current formula is wrong. then, I also find tutorials for you, see

https://docs.microsoft.com/en-us/dax/addcolumns-function-dax

https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax

https://docs.microsoft.com/en-us/dax/summarize-function-dax

https://blog.crossjoin.co.uk/2015/06/01/using-selectcolumns-to-alias-columns-in-dax/

 

 

Best Regards,

Community Support Team _ Tang

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

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago

v-xiaotang 

 

I want to extract the Transactions (column named "Attribute" rows named "Trans") with the value (in the column named "Value") both are in Table named (DailyPlan)

 

For Footfall I want to extract the value from column "Traffic" in the Table named "DailyFootfall"

 

After Divide Trans/Footfall to create a percentage.

 

For both of them be able to make an LFL being able to filter them by Store and dates

[COMP_Active] * ( [OpeningDateAniversary] <= BoP_Date_Fixed ),
[NEW_Active] * ( [OpeningDateAniversary] > BoP_Date_Fixed )
)
 
I don't know if these dates format is correct but well. 
 
Let me know the best option to create this...
 
Thank you so much for your help.Much appreciated