Forum Discussion

powerbignc's avatar
powerbignc
Icon for Helper I rankHelper I
3 years ago

Need Modeling and Dax Help for simple DAX IF

**I am not able to modify these table, so no calc columns or Power Query*** **Transaction Fact table is over 300 Million Rows and lives in SQL** **Screenshots of tables are below text**   I have ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

powerbignc , create a combined column in both transaction table and store table

 

Date Stote = format([Date], "YYYY-MM-DD") & "-" & [Store]

 

Use the correct column from both tables and join them

 

I do not this you will need a store table in that case