End of week, month, quarter, year Command

[Anonymous]

Hello all!

I am beginning a report that displays information regarding the last 3 days of the week, 8 days of the month, 7 days of the quarter, and 14 days of the year. I want to create binary variables for each category, and check the functions against the ship_date column in my dataset which displays dates in general date format, ex: "8/25/2020 3:27:00 PM". I'm having trouble figuring out how to track the last day of each category and then how to work backwards from there. Any help would be greatly appreciated!

Thanks!

[amitchandak]

@Anonymous , not very clear. Refer to my calendar where I have set most of the start and end date

1.Creating Financial Calendar -
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
2.Any Weekday Week -
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

4.Travelling Across Workdays
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766

Or you can check my youtube series

https://www.youtube.com/watch?v=Qt0TM-4H09U&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=5

Can you share sample data and sample output in table format?

[lbendlin]

Save yourself all the hassle and add these flags to your Calendar/Dates table.