The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I request your kind collaboration, I have two columns in a matrix (days), in which I need to subtract them for each row.
So here, I need subtract column "18" minus "17". taking into account that the number 18 is the day of the month, and I need it to be subtracted from the previous day.
Thank you.
Assuming the format of the column is Date you can use
Days Difference = DATEDIFF([Start Date], [End Date], DAY) or please provide the column format ?
Regards,
Jupsimar Singh.
Mark my post as a solution if it helped you !
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
79 | |
72 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
69 | |
64 | |
57 |