Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have my rolling calendar table as a lookup, using a static start value.
Instead I rather use the earliest date from my transaction table, so when I build a date slice it fits perfectly.
How can I do that?
Thanks
Solved! Go to Solution.
Hi @gerdtf84 ,
I hope that you need minimum date from transaction table. If I understood your problem correctly, then you try this,
List.Min(Table.Column(#"Transaction Table", "Date column" ))
Thanks,
Arul
Hello Arul,
thank you for your help. That was exactly what I was looking for.
I tried to integrate step by step and I can retrieve the correct date. But I do not manage to integrate it into my rolling calendar.
this is what I have so far:
startDate = List.Min(Table.Column(#"Sales", "Date" )),
#"Create List Of Dates" = List.Dates(Number.From(DateTime.LocalNow())-Number.From({{startDate}}),#duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(#"Create List Of Dates", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
But I am getting an error cause it seem I am getting a List instead of a Date value. Can you give me a hand here as well?
Thanks a lot for your help.
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |