Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dofrancis3
Resolver I
Resolver I

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 because for the column is empty, I don’t know why please advise:

dofrancis3_0-1739777528277.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @dofrancis3 

 

There's one missing here.

vzhangtinmsft_0-1739952835714.png

vzhangtinmsft_1-1739952872092.png

 

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.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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]
)

vzhangtinmsft_0-1739934711290.png

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.

Dear @Anonymous 

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

dofrancis3_0-1739951566674.png

 

Anonymous
Not applicable

Hi, @dofrancis3 

 

There's one missing here.

vzhangtinmsft_0-1739952835714.png

vzhangtinmsft_1-1739952872092.png

 

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.

Dear @Anonymous,

 

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

 

quantumudit
Super User
Super User

Dear @dofrancis3 

Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.

 

Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.

 

For best practices, you may find the following links useful:

 

Please take a little more time to draft your. Some of the questions related to your initial query are as follows:

 

  • The measure is not fully shown in your screenshot. What is purpose of that measure creating a calculated column?
  • How is the "Quarter" column related to the measure you have shown in the screenshot?
  • What values would you like to populate in last column?
  • What is your expression and what is the exact issue you are facing?
  • What are the expected results you want?

Thanks

Udit

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.