Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Need to create a yearly usage trend

Hi Dax experts,

I have working on analytics and I need to present Yearly trends of viewers' ship of website pages. 

The data has 

1. Page viewed and Date with time ( I have modified the time to dd/mm/yyyy) 

I need a trend analysis of Yearly (since the date given) 2021, 2020, 2019 etc which page was mostly viewed and once I get this, I will use the same to extend to get how long they viewed.

I tried to use this function (Apologies, learning and not sure if this is what I should do) 

but I tried this from Dax guide, Refer: dax.guide/time/

 

--  When the arguments overflow their range, DATE and TIME
--  behave in different ways:
--
--  DATE adds the excess values to the date, moving time forward
--  TIME adds the excess values, but it does never exceed the day
EVALUATE
    {
        DATE ( 2020, 10, 32 ),
        DATE ( 2020, 20, 1 ),
        TIME ( 10, 90, 0 ),
        TIME ( 50, 0, 0 )
    }

 

then this confused me more as power BI says Evaluate is not keyword.  Now as I seek help for my need, I am now confused. Is this dax.guide/time/ not relevant to Power BI ? how do I practice?  Help is appreciated.

 
1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

EVALUATE is used for DAX queries but not for calculated tables in Power BI Desktop.

 

In Power BI Desktop, you can define a new table like this:

AlexisOlson_0-1638824834361.png

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thank you @AlexisOlson . Very helpful

AlexisOlson
Super User
Super User

EVALUATE is used for DAX queries but not for calculated tables in Power BI Desktop.

 

In Power BI Desktop, you can define a new table like this:

AlexisOlson_0-1638824834361.png

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.