Forum Discussion

joaopalhares's avatar
joaopalhares
Frequent Visitor
5 years ago
Solved

Calculating Stores by Transaction Range

Hello,   I would like to ask for help on the following problem:   I have an excel database which have the total number of transactions per store and date.   Then, i summarize the total number o...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    add a new column in table of sheet1

    and, create a relationship between the new column to dimTable

    then change the measure code of StoreCount to

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

add a new column in table of sheet1

and, create a relationship between the new column to dimTable

then change the measure code of StoreCount to

 

joaopalhares's avatar
joaopalhares
Frequent Visitor
5 years ago

Thank you!