Forum Discussion
Tricky DAX Formula
MFelix This displays when trying to add it to a table with other data:
MFelix I have a Date table but I don't have a relationship setup with it. Typically when I build formulas I just reference my date table in the formula if needed:
MFelix I've substitued the Revenue Date for the Date in my calendar table and now I no longer get the error:
Only problem is now it is summing each individual line. I was hoping to get the sum for December (71.28) and multiply that by 12 (855.36) as the answer I was looking for. I don't need totals for older dates, just the latest month. Each month there will be new revenue and revenue dates and I will need to take the total for the new month and multiply it by 12.
Hi Anonymous,
Do you want to dispaly the information as you have in your print screen?
Measures are calculated based on context so when you add the full date field, it will make the sum for each individual row and not for the aggregated month. If instead of date you add in Month/year this will give you the sum per month since it will be getting the information for all the dates within the month.
If you have the need to show individual dates do you want t have single day information or cumulative?
Regards,
MFelix