Need to create a yearly usage trend

Anonymous — Mon, 06 Dec 2021 14:34:01 GMT

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.

Re: Need to create a yearly usage trend

AlexisOlson — Mon, 06 Dec 2021 21:07:26 GMT

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:

Re: Need to create a yearly usage trend

Anonymous — Mon, 06 Dec 2021 22:05:57 GMT

Thank you AlexisOlson . Very helpful

topic Re: Need to create a yearly usage trend in DAX Commands and Tips

Need to create a yearly usage trend

Re: Need to create a yearly usage trend

Re: Need to create a yearly usage trend