Forum Discussion

NataliyaD's avatar
NataliyaD
New Member
10 years ago

StartOfDay question

Hi ! I tried to use StartOfDay function in new column (I have datetime values but I need day report - and diferrent records has different hours and minutes. I work with Azure database and use DirectQ...
Need Help
NataliyaD's avatar
NataliyaD
New Member
10 years ago

Thank you

!

It worked.

 

But I created a new weekly query and now Date.StartOfWeek is not "good" for live stream also (while I do have on report on dashboard where it works - have no idea what is the difference)

 

Any suggestion how can I create date unique for the week ? (preferably start of the week but any unique date will be ok)

Thank you !

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Apologies, I'm not understanding what you are asking for. A unique date for the week?

  • NataliyaD's avatar
    NataliyaD
    New Member
    10 years ago

    Sorry :-(

     

    I have a datetime value in my records and I wanted to create weekly report.

    StartOfWeek function looked promising, but for some reason it worked for one of my live reports and not accepted anymore for others (may be after last update of power bi)

     

    It doesn't have to be start of the week - just some way to count records by week.

     

    Thank you very much !