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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
marcus505
Frequent Visitor

subquery

Hi All ...

I have a table with threee drop down fields [Type A,B,C,D] and want to sum by values selected over a period of time - see format shown below. All the three fields are in one table.

I guess i need a subquery or multiple select statement to return each value and then use a Matrix table ? Whats the best approach ?matrix.png

 

Many Thanks,

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @marcus505,

 

Really sorry for the delay.

 

Is the image you shared your data sample?

 

I'm still a little confused about your requirement.


 

I have a table with threee drop down fields [Type A,B,C,D] and want to sum by values selected over a period of time - see format shown below. All the three fields are in one table.

 

It seems that you want to sum by values with selceted over a period of time.

 

Do you want to calculated the values for each type when select the week x in slicer?

 

I would appreciate it if you could share your expected output so that we could help further on it.

 

Best  Regards

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Cherry,

 

Thank you for your response.

 

A record has four fields [Type A,B,C,D] with different values to select.

 

I want to sum by values selected for each record on a weekly basis. Sorry for the confusion

 

Only one value can be selected per [Type] 

 

Many Thanks

marcus505
Frequent Visitor

any ideas - is this possible ?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors