topic Re: Synchronize dates of two tables in Brasil

Synchronize dates of two tables

MarioCenteno — Fri, 14 Sep 2018 00:06:00 GMT

Help me.

I need to synchronize the dates of two different tables, it happens that when I select the date F_IFR it shows me a value but if I select F_UCE it shows me another I want to join the two dates so that the data selection is unique.

Expression measure

SUM({<[F_IFR.autoCalendar.Year]={'$(vMaxYear)'},

[F_IFR.autoCalendar.Month]={'$(vMaxMonth)'},[F_IFR.autoCalendar.Day]={'<=$(vMaxDay)'},

F_IFR=,[F_IFR.autoCalendar.YearMonth]=>}SALES)

Re: Synchronize dates of two tables

Thiago_Justen_ — Fri, 14 Sep 2018 00:13:59 GMT

Mario,

Take a look here:

Re: Integrar Datas

Canonical Date

Re: Synchronize dates of two tables

MarioCenteno — Fri, 14 Sep 2018 00:32:04 GMT

Hi Thiago

I followed your example but something I'm doing wrong, you could help me a little more please.

Now it does not show me data.

Re: Synchronize dates of two tables

Thiago_Justen_ — Fri, 14 Sep 2018 02:13:34 GMT

Are you able to share a mock up?