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.
