Forum Discussion
Reference a previous month using variables in DAX using slicers
Hi I am trying to reference the last week using some dax code that Greg_Deckler provided. I got the last week working but it only works after the firstr week in a given month. How would I ...
Yep
three tables
one contains date
two contains internet page impressions targets
three contains ga page impressions
There is a week num column in each table and 2/3 joins the calendar table via the date column
Tried what you suggest but it throws up the error
MdxScript(Model) (9, 73) Calculation error in measure 'GA'[Last Week Targets]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
All values are whole numbers.....
After some more testing it seems it does not like the YEAR function