Combine two dimension to one

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Combine two dimension to one

techvarun — Tue, 13 Feb 2018 09:30:51 GMT

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)))