79678317

Date: 2025-06-24 23:20:06
Score: 1.5
Natty:
Report link

What does your table structure look like? It may be that you need to restructure (unpivot) so your table is set up like (Date, ProductID, CycleNo, Amount)

If it is, you can use CALCULATE( SUM(Amount), FILTER(DimCycle,CycleNo = MAX(Fact[CycleNo])-1) ) to get the previous cycle value

Reasons:
  • Whitelisted phrase (-1.5): you can use
  • Low length (0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): What do
  • Low reputation (1):
Posted by: Pieter Linden