Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have a formula that is used in a matrix that calculates the my (Open Orders + Ships) - FC qty.
it was Set up as an iterating view in SQL that can no longer be used.
the Formula for Open slots is (OpenOrder +Ships) - FCqty + IF(X>0, X, 0)
x is equal to the previous months open slots.
is there a way to do this in a DAX formula?
hi @effertz12
You can add a calculated column like:
my data set is individual orders and ships on one table and forecast for those items in a sepereate table. I cant calulate at the table level because we have different groupings that i need to be able to choose between which would mean i would need a table for every grouping we choose.
or you already have the Y column, but expecting something like:
my current formula evaluates OpenOrder+ships - FC for all the previous months up to the current month. Is there a way to not include months in which the OpenOrder+ships - FC formula goes negative? for example, in my picture above April would evaluate only the months of march and april but exclude febuary from the calc as it was negative in that month
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |