HI
I want to get prevous year week values . Without hardcoiding means
week-52
How can i achevie that
Previous year is week format & when ever the 53 week comes that data come that show not go current year 1 st week
Hi, I am not 100% sure what is the end goal of this, but it sounds like you could try using OFFSET and maybe RANK to try finding solution to this.
i want to get previous year weeks to the current year . but Whenever the the 53rd week comes thats should be stand alone . which means the 2022 53 rd shouldld not comes to 1st week of 2024 . But Offset will not work bcz of timeperiod format and don;t know about the rank
@kishoreanimi
Have you tried the AddYear() function? That returns a date and then you can wrap that function within the Period() function.
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
