Forum Discussion

dofrancis3's avatar
dofrancis3
Resolver I
1 year ago
Solved

Selectect columns fonction

Dear colleagues. Could you help me to fix this issue, as per my table and Measure below I would like to have the values in my last column (Quarter) please could you help me to fix the measure becaus...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, dofrancis3 

     

    There's one missing here.

     

    Best Regards,

    Community Support Team _Charlotte

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, dofrancis3 

 

I've briefly simulated some data in the hope of solving your problem. You can try the following formula.

New Table = 
SELECTCOLUMNS(BizOPs_dataset,
    "Country", BizOPs_dataset[Country],
    "Year", BizOPs_dataset[Year],
    "Quarter", BizOPs_dataset[Quarter],
    "Antigen", "DPT1",
    "Age Group", "12-13 months",
    "Does Cumulative", [Measure]
)

Please refer to the attachment.

 

Best Regards,

Community Support Team _Charlotte

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

  • dofrancis3's avatar
    dofrancis3
    Resolver I
    1 year ago

    Dear Anonymous 

    As you can see it doen't work if i would like to use more measures and collumns please advise

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, dofrancis3 

       

      There's one missing here.

       

      Best Regards,

      Community Support Team _Charlotte

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

      • dofrancis3's avatar
        dofrancis3
        Resolver I
        1 year ago

        Dear Anonymous,

         

        Thank you for your support but please how can i avoid duplications (raws) in this measure