Forum Discussion
mp390988
Post Partisan
Post PartisanDATESYTD function
Hello, I have a measure defined as: RevenueYTD = CALCULATE( [Revenue], DATESYTD('CalendarTbl'[Date]) ) When I drop this measure into my visual, it does not show any values, as...
Hi FBergamaschi ,
I realised that I had more than one table marked as date table. For example, I had both the Calendar and CalendarTbl marked as Date tables. As soon as I turned off Calendar as being Date table it worked!
Thank You
FBergamaschi
Super User
Super UserOK, can you please share the model? I need to check it. It should perfectly work, but I need to open it. I shall send you a provate message now.
mp390988Post Partisan
Post PartisanHi FBergamaschi ,
I realised that I had more than one table marked as date table. For example, I had both the Calendar and CalendarTbl marked as Date tables. As soon as I turned off Calendar as being Date table it worked!
Thank You
- FBergamaschi
Ok please mark the solution and kudos to whom helped you please
Thx