Forum Discussion

canary's avatar
canary
Regular Visitor
8 years ago

Calculating Stock Days

Hi, I'm newbie with Power BI, DAX and reports. I hope you can help me. Thank you! I created a new measure which calculates the difference between two dates from a filter, but when i use the meas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

canary,

Do you mean that the Column diff field doesn't change based on slicer selection? If so,  this behavior is expected as  calculate columns are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report.  for more details, please review this Knowledge base.

Based on your description, you want to calculate stock days, could you please share dummy data of your tables and post expected result here?

Regards,
Lydia

  • canary's avatar
    canary
    Regular Visitor
    8 years ago

    Hello Anonymous, sorry for delay. I was working hard this week.

    I understand your response. The calculated columns which select the values from measures cannot change dynamically.

    So... then it's possible to do with measures?

    I can provide a CVS file of the last 100 sales of a product.

    I cant provide with more because isnt my company .

    In this set, if I use the time slider, I wanna take the following results with 200 stock units:

    Formula= (Stock / Sales) * Days

    Seeing the table, from all the time I sold 125 units in 223 days. Result = (200/125) * 223 = 356,8

    But if I select the dates from January 02/01/2018 - 10/01/2018 (spanish format), I have that i sold 51 units in 8 days. Result = (200/51) * 8 = 31,37

    Its possible to do this for each product?

    Thank you and sorry for de delay again.

    This is the file link.csv