Forum Discussion
DAX
Hello,
I have Table with 3 columns Project Number, Project Cost and extraction Date.
Each end of month, i do extraction to know the cost of each project.
How to write dax powerbi to calculate the changes of the only running projects over months, and exclude the First record of project number i.e. first Date "in extaction date" of Project number - But to start count thos new record from the second month as long as they existed ?
5 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Project number Value Date PF-10329438 EGP 127,194.00 10-24-2022 PF-10358883 EGP 2,336,586.00 10-24-2022 PF-10473993 EGP 6,462,543.00 10-24-2022 PF-11182775 EGP 338,486.00 10-24-2022 PF-38105310 EGP 2,776.00 10-24-2022 PF-10329438 EGP 127,194.00 11-22-2022 PF-10358883 EGP 2,336,586.00 11-22-2022 PF-10473993 EGP 6,462,543.00 11-22-2022 PF-11121349 EGP 58,393.00 11-22-2022 PF-11182775 EGP 336,577.00 11-22-2022 PF-38105310 EGP 2,776.00 11-22-2022 PF-10329438 EGP 127,194.00 12-16-2022 PF-10358883 EGP 2,336,586.00 12-16-2022 PF-10473993 EGP 6,467,543.00 12-16-2022 PF-11121349 EGP 58,393.00 12-16-2022 PF-11182775 EGP 336,577.00 12-16-2022 PF-38105310 EGP 2,776.00 12-16-2022 PF-11121349 EGP 58,393.00 1-19-2023 PF-11182775 EGP 401,017.00 1-19-2023 PF-38105310 EGP 2,776.00 1-19-2023 PF-11121349 EGP 58,393.00 2-2-2023 PF-11182775 EGP 401,017.00 2-2-2023 PF-11121349 EGP 58,393.00 3-2-2023 PF-11182775 EGP 401,017.00 3-2-2023 PF-11121349 EGP 58,393.00 4-4-2023 PF-11182775 EGP 401,017.00 4-4-2023 Hi,
Clearly show the exact result that you are expecting.
Hi,
Show the result in a spare column of the sample table that you shared.
