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.
Trying to create a column that shows how many days since something was effective. I have a data tabe that gives me
Agency Name | Client Name | Effecitve Date |
Test | Jane Doe | 12/23/2024 |
I created a Date Table. But can't seem to get the formula to work to show how many days since the Effecitve Date.
Solved! Go to Solution.
@inglexjc
Add this as a Calculated Column to the above table:
Days Since Effective Date =
INT ( TODAY () - [Effecitve Date] + 1 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@inglexjc
Add this as a Calculated Column to the above table:
Days Since Effective Date =
INT ( TODAY () - [Effecitve Date] + 1 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group