Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to show value per week

Hello guys, I am having a problem in my data model. I have two tables, Target and Calendar  in the Target Table I have the Target Date that is a single day of the month for each month and it conta...
Need Help
Show and Tell
Tips and Tricks
  • Bmejia's avatar
    Bmejia
    2 years ago

    Make sure your date fields are formatted as date in particular the 'Data Inicial'.  You can try this see if this fixes the issue.  Create a new column in your fMetas table refering to the Data inicial. Then join this column with your date table instead of directly from the data inicial column.

    DateValidation = DATE(
    YEAR(fMetas[Data Inicial])
    ,MONTH(fMetas[Data Inicial])
    ,DAY(fMetas[Data Inicial])
    )

Bmejia's avatar
Bmejia
Icon for Super User rankSuper User
2 years ago

Make sure your date fields are formatted as date in particular the 'Data Inicial'.  You can try this see if this fixes the issue.  Create a new column in your fMetas table refering to the Data inicial. Then join this column with your date table instead of directly from the data inicial column.

DateValidation = DATE(
YEAR(fMetas[Data Inicial])
,MONTH(fMetas[Data Inicial])
,DAY(fMetas[Data Inicial])
)