Forum Discussion
Helper IIDax logic not working
Hi ClaudioF ,
To confirm if the issue is related to the source, you can export the data from the internal source to an Excel file and use it in a non-working dashboard, then see if the issue persists.
You can also:
Check that the field types (numeric, text, date, etc.) are the same in both the Excel source and the internal source; there may be null values or formatting irregularities in Excel.
Confirm that the table relationships and sorting rules in the two data models are identical.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Helper IIAnonymous Thankyou for yout repply, i just found the problem, that was wiht the logic, when running if the value of the item was bigger than the available stock, then the logic worked, but, when the quantity was smaller than the stock but the stock was allready used, the logic summed and then keeps summing.. still trying to find the solution