Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all
I am trying to create some kind of formula that would work based on a selected value/what if parameter. My what if parameter is how many days of stock I want to have on hand - it is whole numbers from 1 - 60.
Then I have created a summary table that has Item ID, Month, Average items sold per day, and total items sold during that month. I want to create a formula that multiplies the average number of items sold per day by the stock days on hand (what if parameter). Here is what I've tried -
Solved! Go to Solution.
Try
Inventory Units =
DIVIDE (
SUM ( 'Order Data'[ORIG_ORDER_QTY] ),
DISTINCTCOUNT ( 'Order Data'[Date Time] )
)
* SELECTEDVALUE ( 'Days of Inventory'[Days of Inventory] )
What is the relationship between the two tables? How does your visual look like?
Between which two tables? The summary table? Right now I only have the one table and the what-if parameter, which I have not connected to anywhere. The Days of Inventory is a what-if parameter that simply contains numbers between 1-60.
That is strage. Must be something in the visual. But ofcaurse you select only value right? Can you please share a screenshot
I officially got it to not be blank, but now it's all the same value -
Try
Inventory Units =
DIVIDE (
SUM ( 'Order Data'[ORIG_ORDER_QTY] ),
DISTINCTCOUNT ( 'Order Data'[Date Time] )
)
* SELECTEDVALUE ( 'Days of Inventory'[Days of Inventory] )
I think this worked! Double checking it now manually to make sure, but it looks good!
Hi @Thigs ,
May I ask if your problem has been solved? Did tamerj1's post above help you? If any of the posts are helpful, then please consider accepting it as a solution to help other members find it faster. Many thanks!
Best Regards,
Community Support Team_Gao
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
21 | |
20 | |
14 | |
13 |
User | Count |
---|---|
43 | |
37 | |
25 | |
24 | |
23 |