Forum Discussion
Helper VMTD measure
Anonymous Many thanks mate.
Still for some reason, what you have suggested did give me blank figures when I filter "current month" however you gave me the idea of doing the following:
I created a duplicate column for (meAccountTransaction[TransactionDate]) changed the format to date only and then created a direct relationship between (meAccountTransaction[TransactionDate]) and (meCalendar[DateValue])
Appreciate your help, it was a spot on. am getting the figures up to the minute!
The columns in the relationship must be the same. If one is datetime and the other is date only, there will be zero matches between the two columns.
majdkaid22 no, those formulas should all work as written. How are you applying Is Current Month? Are you using it in a visual filter or are you actually referring to it in another formula?
Helper V
Here's a screenshot Anonymous I applied it as a column, and I add it as a filter on the page.
and here's how my MTD measure is written: MTD Deposits = CALCULATE(SUM(meAccountTransaction[Deposits]), DATESMTD(meCalendar[DateValue]))
majdkaid22 I cannot replicate that. It works fine in my test. Are you sure there's not another visual level filter on that blank card?
Silly question, you do have a table relationship between meAccountTransaction[TransactionDate] and meCalendar[DateValue] right?
- majdkaid22
Anonymous Yes between ValueDate in Calander and TransactionDate in meAccountTransaction
- majdkaid22
Anonymous apologies, the relationship is between CalendarDateID and PostingDateID
I think my DateValue and TransactionDate need to have the same format before they can be linked together no?
If the relationship then between those 2, it should be all solved?