Forum Discussion
Calculate Function - Not Working!
Hi! For Revenue, just make the measure be Revenue = SUM('Your Table'[Revenue]) then in the visual, put the week numbers in and put in the Revenue measure - it will show you your revenue per week naturally.
Since the figures are repeating that usually indicated that you don't have the date table joined to the fact table. Check to see if you have the join and if it is there, double check that it is working properly (i.e. put date from fact in a table and date from dim date in the same table and see if both columns are filled in).
Hi! For Revenue, just make the measure be Revenue = SUM('Your Table'[Revenue]) then in the visual, put the week numbers in and put in the Revenue measure - it will show you your revenue per week naturally.
audreygerred I tried that too didn't work.
It only works when I create a new column with week numbers in the same table. Not when the week numbers are in another table.
Since the figures are repeating that usually indicated that you don't have the date table joined to the fact table. Check to see if you have the join and if it is there, double check that it is working properly (i.e. put date from fact in a table and date from dim date in the same table and see if both columns are filled in).
Thank you so much! Yes, there was an error in the relation.
You're very welcome!