Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Thanks a lot
Nikola
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
Hi @nivanovic,
It seemed that your link could not access your file:
Could you please upload your file again?
Regards,
Daniel He
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |