Forum Discussion
Variable target weight
Hi, I'm looking at a logistics dashboard where targets need to be readjusted based on the current period and since I'm new to PowerBI I'm looking for the best method. The situation is as foll...
Hello you could try to use DATEDIFF
13Weeks:=CALCULATE(SUM(Freigt[Weight]),DATESINPERIOD(TODAY(),13*7,days))
%13Weeks:=Divide([13Weeks]/400
With 4 weeks it is similar.
Thanks Florian,
I did think about something like it, but the thing is that the weight is going down per week, from week 4 onwards, until being 0%. I believe the formula will become increasingly complicated?
Hello, can you give some simplified sample data and your expected result?