cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naoyixue1
Super User
Super User

Do the further calculation of measure, using column data

Hey there,

 

I now have the measure to calculate the weekly forecast in bottle in SKU level. But I try to furhter calculate that measure based on the relationship between bottle and case in SKU level, coverting the measure from bottle to cases....

 

Right now, i have the SKU lookup table ,which indicates the relationshio between bottle and cases for each SKU. But it seems I really cannot link that relationship in the table to do the further calculation of my measure. Given that, I applied the ADDCOLUMN DAX to try to add the SKU level forecast in my SKU lookup table, but failed.

 

DO you guys know what I should do to solve that issue? Thanks.

2 REPLIES 2
naoyixue1
Super User
Super User

Thanks Phil...See below.

In the right hand side, I caculated  a measure which indicate the rolling 28 days SKU consumptions %, naming 'Transaction %'. Now. I applied that trasaction % in SKU to break down the aggregated level forecast to the SKU level in bottles.  But I also need to show the forecast in case in below table in red. But just no idea how I can convert the forecast from bottle to case, based on the existing relationship in SKU lookup table. 

 

I tried to created a virtual table to include SKU, SKU bottle forecast and case to bottle relationship, but the SKU bottle level forecast doesn't show up.... might be there are the other ways for me to have the forecast in case....Thanks!

naoyixue1_2-1611278361567.png

 

PhilipTreacy
Super User
Super User

Hi @naoyixue1 

Can you please supply your PBIX or at least some sample data and the code for your measures. Too hard to figure this out without any data to see.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.