Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Folks -
Im looking for a solution to something I would imagine to be very simple. Please help!
In the below screenshot you will see a visual which illustrates when specific product's inventory levels go to 0. Once 0, another column starts to calculate "Days not Allocated". I would like to retrieve the LASTDATE that SKU had a Days Not Allocated of 0.
For the selected SKU that date would be 5/27/2020.
If anymore information is need please let me know.
Thanks!
Solved! Go to Solution.
@AlexAlberga727 - Perhaps:
Measure = MAXX(FILTER('Table',[Avail Qty] > 0),[Date])
If a column. If a measure, create a table variable that represents the data in your visual (summarized by date for instance, use ADDCOLUMNS to add your measure, do your MAXX over that table variable.
Try the following:
measure = CALCULATE(LASTDATE(Table[Date]), [DaysNotAllocated] = 0)
If my answer resolves your issue, please give Kudos and mark as solution.
Thank you
@AlexAlberga727 - Perhaps:
Measure = MAXX(FILTER('Table',[Avail Qty] > 0),[Date])
If a column. If a measure, create a table variable that represents the data in your visual (summarized by date for instance, use ADDCOLUMNS to add your measure, do your MAXX over that table variable.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |