Forum Discussion
SAMEPERIODLASTYEAR
Hi there, I'm using the formula below to get last year's value: Yield-1Y = CALCULATE(SUM('US Treasury'[Yield]),DATEADD('US Treasury'[Date],-1,YEAR))
or
Yield-1Y = CALCULATE(SUM('US Trea...
Anonymous , first you should date table with time intelligence
Do you want to work with only working days?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check this example
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766
yes only working days amitchandak