Forum Discussion

siumui's avatar
siumui
Icon for Helper I rankHelper I
5 years ago
Solved

Need help to update existing column

Hello,   I thought I post my question already but I couldn't find it anywhere.  So I'm posting it (again), hopefully I don't have 2 different posts for the same question.   Is it possible to upda...
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    siumui 

    You will need to create a new table (under "Modeling" in the ribbon, "New Table") for the samples using:

    Sample Table = 
        SAMPLE(5, Cash, 0)

     The create the following measure:

    Yes = 
    IF(
        COUNTROWS(
            INTERSECT('Sample Table', 'Cash')) = 1, 
            "Yes", "No")

     

    and you will get this:

  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    siumui 

    You must be aware that when you create new tables, these are loaded when the whole model is loaded; they are not created "over time".

    So you can just directly create one single table with 6 random rows. If there is a specific reason for creating them separately (given that they will be created simultaneaously when the model is loaded), then you can create a new table for one row and use UNION to append them.