Forum Discussion

KristinaBakic's avatar
KristinaBakic
Frequent Visitor
10 years ago

How to use the CALENDAR() function? A practical example?

Hi! I'm struggling to understand how to use the new CALENDAR-function. It's a new function, so no info of it's use is really around. Could someone provide a real world example on how to use it? Is i...
Need Help
konstantinos's avatar
konstantinos
Memorable Member
10 years ago

I am also struggling to find a real world scenario to use, tried but didn't manage to make it work..For sure is not for marking a table as a date table - mark as date table will be come in later releases..Maybe ( without being 100% sure ) they will make sense when Calculated Table feature released and help create date tables in DAX..

 

 

http://community.powerbi.com/t5/Desktop/How-to-mark-Date-table/m-p/3202#M591

 

 

 

 

WillT's avatar
WillT
Community Admin
10 years ago

Since we released the Calculated Tables work I thought I'd post a couple of articles back here:

 

Here's an intro to how calculated tables work: 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-calculated-tables/

 

and for reference, here's an outline for the CALENDAR function

https://msdn.microsoft.com/en-us/library/dn802546.aspx

 

Hope that helps! Please click 'Accept as Solution' so we know the thread's been resolved!

Thanks