Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a problem concerning two dates dimension from two different tables.
I've solve the problem when looking at months by doing below.
However, I also have to look into weeks and days. And doing that the same way as above would be to much work, and inefficient.
So how can i accomplish above solution in another more simpel way?
-----------
Stefan
In the environment variables Changes monthnames as below
SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
and use the below code in dimention
=If(BookingMonth and Month(Orderdate)=1,BookingMonth &'-'& Month(MakeDate(2018,BookingMonth)))