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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nivanovic
Frequent Visitor

to deduct measure per each week as a fixed value

Hello Everybody,

 

 

I'm dealing with a little issue right now. I have to calcualte Est Inventory where I need to deducct measure (Sales /w (12 w) from location Inventory per weeks. The Problem is: the measure (sales/w (12) doesn't  reflect per weeks in the table, therefore I had to calculate it in Dim Date Table which is not affected by filters. Has anybody got an idea how to solve this? See some example data below and thank you very much for every response .

 

I need help with deduting measure which is average sales per week as a fixed value per week.

 

Please refer to the file below and excel calulation.

 

https://onedrive.live.com/?id=F3E5FDFD8DBDA024%21104&cid=F3E5FDFD8DBDA024

 

Excel calculationExcel calculation

 

 

Thanks a lot

Nikola

 

4 REPLIES 4
Anonymous
Not applicable

Are you trying to do this in Excel or in Power BI? Both work very differently and If you are trying to do in Power BI, then you should train yourself to not look at it like excel, else there would be lot of confusion.

 

Ideally, you should show how the tables are structured in power bi, with some sample data and the desired output.

Thank you foryour qucik reponse.

 

I'm trying to do it in Power BI. Is there a solution to this issue in Power BI.

 

I need calcualtion Location inventory - Sales/w (12w) cumulative where sales/w (12w) is a fixed value per each line/weeks

 

There is a link below to my file and screenshot.

https://onedrive.live.com/?id=F3E5FDFD8DBDA024%21104&cid=F3E5FDFD8DBDA024

 

 

Location Inventory - Sales/w 12w CumulativeLocation Inventory - Sales/w 12w Cumulative

Hi @nivanovic,

It seemed that your link could not access your file:

1.PNG

Could you please upload your file again?

 

Regards,

Daniel He

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

Hi Daniel,

 

Can you try the link below? 

https://1drv.ms/u/s!AvHpWQt6k0CkbWaxyK9r90HEavM

 

It should give you direct access to the file, otherwise I will give you my password and username.

 

I ususally use "Get link", t to get the direct link to the file. If there is any other way, please let me know.

 

Thank you for your support.

 

Kind regards,

 

Nikola

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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