Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have this requirement of selecting the date for the cell where there is negative quantity and then perform further computation upon it
I m using a matrix visual for representing my data in power bi.
As an example in the screenshot above i need to get the date for which negative quantity starts appearing i.e 3/30/2018 in this case.
What are you using for the Values field? Seems like you could do a simple IF statement for <0 and then do you further computations.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi,
Please find my sceenshot below:
There exists a Many to One relationship between the Shortages and Calendar;Shortages and ItemInfo.
Shortages is being derived from the table ShortageData.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |