Forum Discussion
Retrieve the Lastest Available Allocation when Month is Zero
- 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.
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.