Forum Discussion
Help! Previous Month Function is not working!!
You need to create Date Calendar and join it with your current table. Time Intelligence function only work with Date Table.
Even your MTD function will not work if you put Date Values in Table. Since you are showing Location thats why it is giving sum of location for that month. but if you put date column in Matrix/Table you will see that MTD will not work as expected.
You need to create Date Calendar and join it with your current table. Time Intelligence function only work with Date Table.
Even your MTD function will not work if you put Date Values in Table. Since you are showing Location thats why it is giving sum of location for that month. but if you put date column in Matrix/Table you will see that MTD will not work as expected.
I have my date table connected to the table with my values. Or did I do this incorrectly?
You are pulling date from BPC table in your measure, you should be using date from "Time Map" table (if this is your date table)
I had the same issue. It was solved by marking my Calendar table as the date table:
