Forum Discussion
yforti
Helper II
Helper IIPrevious month calculated measures
I need to calculate the total of the (VlConta A Vencer) column for the two months prior to the current month. The current month's data doesn't matter in my model. For example, we are in the month of ...
yfortiHelper II
Helper IIamitchandak
I created a time table as you can see:
calendario = CALENDAR(DATE(2007,1,1),DATE(2025,1,1))
After that i created a relationship between the Calendario(date) table with the DT_ENTRADA in my database, see below:
The problem is that I'm not getting any results, for example:
I have a sales measure that is:
vl conta = CALCULATE(SUMX('visao_etapa_conta - Não Remetidas','visao_etapa_conta - Não Remetidas'[VL_CONTA]))
, see the result WITHOUT having any relationship with the calendar table:
See the result after creating the relationship between the tables:
Why is the result blank when using the time table date?