Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a following source table:
Contract ID | Start Date | End Date | Value |
A1 | 2020-12-01 | 2021-12-31 | 100 |
A2 | 2021-03-01 | 2022-12-31 | 200 |
A3 | 2021-05-01 | 2023-12-31 | 300 |
I'm trying to create a calculated table with contracts, which expire before 2023-01-01 and at the same time Start Date and End Date will change to Expiry Date plus 1 day, so in results I'll get:
Contract ID | Start Date | End Date | Value |
A1 | 2022-01-01 | 2022-12-31 | 100 |
A2 | 2023-01-01 | 2023-12-31 | 200 |
I know how to create calculated table:
CALCULATETABLE (
'tblContractList',
'tblContractList'[End Date] < DATE ( 2023, 01, 01 )
)
But how to replace the values in Start Date column in calculated table based on values from End Date column from the source table?
Why would you want to do it in DAX instead of Power Query? Is it not easier, faster and more efficient to do the transformation in PQ?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |