The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I need my visuals to display data over time as "Week-End" Date. I've included what I have in my date table and a sample graph. "Week Number" isn't very telling in and of itself, so I need the visual to display that week is "3/7/2020." My weeks run Sun-Sat.
This file has a calendar, where weekend date has been calculated .refer
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Week End date = DATEADD('Date'[Date],7-1*WEEKDAY('Date'[Date]),DAY)