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,
I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.
Thank you