Forum Discussion
Month on Month - % difference
Dates will only need to be unique within the date table itself. The relationship should be fine between the two.
I think I know where your issue is. Your date table is just that, a date table. Your publshed Date is actually a DateTime. What you might need to do is create a new calculated column which is the same as your Publised Date, but without the time component. Try this DAX in a calculated column:
Key Date = DATE(YEAR([Published Date]), MONTH([Published Date]), DAY([Published Date]))
Now link the Key Date with your date table.
Thank you so much, Ross! All looks to be linked now!
Unfortunately, I'm still having a bit of trouble with the month-on-month etc. calcs. The quick measures don't seem to work for me, so perhaps creating the calculated columns is best?
I tried your original formula but it didn't seem to work :(
If, for example, I wanted to a month on month change for some of the below columns, what sort of formula would I use? My table name is called POST DATA.
Also, do you find the KPI card most effective for showing currently month and change % as a visual?
Thanks again for all of your help, Ross- greatly appreciated! Hopefully one day I'll know as much as you do!