Forum Discussion
Formula Returning Blank
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
To use the built-in Time Intelligence functions, you need to have a formal Calendar table that has been "Marked as Date Table"
This table needs to have ALL of the dates in a year, even weekends and holidays.
A relationship then needs to be created between your CalendarTable[DateColumn] and your 'M3 Billing'[Invoice Date]
SQLBI has a great Date table in their template file for free download. Check out this article for more information.
Note that this table is likely overkill, but it has been designed to work in nearly EVERY use case.
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