Thanx for your help.
I Understand, but how can i do that with dynamics datas?
I suppose that we must test if values exists for all years?
If not exist then add line in concatenat statement?
Could you tell me more?
LOAD * inline [
Parts, Date, Val, Year
Part1, 01/01/2014, 0, 2014
Part2, 01/01/2013, 0, 2013
Load *,Year(Date) as Year;
LOAD Parts, Date#(Date,'DD/MM/YYYY') As Date, Val inline [
Parts, Date, Val
Part1, 01/01/2015, 1
Part1, 02/01/2015, 1
Part1, 03/01/2015, 1
Part1, 01/01/2013, 1
Part1, 02/01/2013, 1
Load distinct Year Resident Temp;
Load Parts,Year,Alt(Sum(Val),1) As Sum Resident Temp Group by Parts,Year;
Drop Table temp;
Use this instead to dynamically create the missing records:
Concatenate(T1) LOAD *, Year(Date) as Year; LOAD FieldValue('Parts',RecNo()) as Parts, date(makedate(FieldValue('Year',IterNo())),'DD/MM/YYYY') as Date, 0 as Val AutoGenerate(FieldValueCount('Parts')) While IterNo() <= FieldValueCount('Year');
Thanx for your code. With it, i can see that many records are created in my table.
But... In my table with SUM expression, i can't see years where val = 0...
I've tried to check "Show all values" in dimensions properties but it's not working.
I use set analysis in my expression is that the problem?
My expression is :
I've tried to use ALT function but it's not working my expression was :