Forum Discussion
swwong1
Helper III
1 year agoRetrieve the Lastest Available Allocation when Month is Zero
Hi All I have a table with a list of projects that we log every month. The person allocated to them can change every month so we have monthly data (StarterFlag and FinisherFlag are Custom Columns...
- 1 year ago
Hi swwong1,
Thank you for reaching out to the Microsoft fabric community forum. Thank you Irwan Ashish_Excel for your input on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario.Dax Measure:
Final Allocation Excluding Novak = CALCULATE( SUMX( SUMMARIZE( FILTER( fTransaction, fTransaction[Salesperson] <> "Novak" ), fTransaction[Salesperson], fTransaction[Project], 'dDate'[Month Name], "Alloc", MAX(fTransaction[Allocation]) ), [Alloc] ) )Output:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
v-saisrao-msft
Community Support
1 year agoHi swwong1,
We haven’t heard back from you in a while. If your issue has been resolved, please mark the relevant response as the solution to help fellow community members.
If you still need support, Please let us know if you still need assistance.
Thank you.