Forum Discussion
Formula Returning Blank
I'm simply trying to capture the sum of revenue for the previous quarter. Is there any reason why this formula isn't returning anything at all?:
Anonymous,
Your DAX is correct. Please drag year field or date field with the measure to table visual, otherwise you will get blank values.
Regards,
LydiaHi Anonymous,
As Anonymous mentioned, bringing in Year/ Date field to your visual should fix this
Regards,
Thejeswar
Anonymous I see. I think my desktop version must be outdated. Don't have that option unfortunately so I will need to do it through DAX...
Anonymous, it still needs to be done in DAX, but you need to have your model properly set up in order for those DAX functions to work as expected.
There are a lot of good articles out there on Time Intelligence using DAX (and how to properly set up your data model for it). I recommend looking at this link from Matt Allington