Forum Discussion

eghusseinr's avatar
eghusseinr
Frequent Visitor
3 years ago

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 ...
DAX
eghusseinr's avatar
eghusseinr
Frequent Visitor
3 years ago
Project numberValueDate
PF-10329438EGP 127,194.0010-24-2022
PF-10358883EGP 2,336,586.0010-24-2022
PF-10473993EGP 6,462,543.0010-24-2022
PF-11182775EGP 338,486.0010-24-2022
PF-38105310EGP 2,776.0010-24-2022
PF-10329438EGP 127,194.0011-22-2022
PF-10358883EGP 2,336,586.0011-22-2022
PF-10473993EGP 6,462,543.0011-22-2022
PF-11121349EGP 58,393.0011-22-2022
PF-11182775EGP 336,577.0011-22-2022
PF-38105310EGP 2,776.0011-22-2022
PF-10329438EGP 127,194.0012-16-2022
PF-10358883EGP 2,336,586.0012-16-2022
PF-10473993EGP 6,467,543.0012-16-2022
PF-11121349EGP 58,393.0012-16-2022
PF-11182775EGP 336,577.0012-16-2022
PF-38105310EGP 2,776.0012-16-2022
PF-11121349EGP 58,393.001-19-2023
PF-11182775EGP 401,017.001-19-2023
PF-38105310EGP 2,776.001-19-2023
PF-11121349EGP 58,393.002-2-2023
PF-11182775EGP 401,017.002-2-2023
PF-11121349EGP 58,393.003-2-2023
PF-11182775EGP 401,017.003-2-2023
PF-11121349EGP 58,393.004-4-2023
PF-11182775EGP 401,017.004-4-2023
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Clearly show the exact result that you are expecting.

    • eghusseinr's avatar
      eghusseinr
      Frequent Visitor
      3 years ago

      As the list above is a sample, i want to make a dax "Formula" that calcalate the Delta in value from month "M" to previuose Month "M-1" to each project. But Also exclude the first date vaue of that project from this formula.

      i.e.

      Project Number :PF-10329438 , the first record was in Oct. 2022, 
      so
      Delta November for PF-10329438 = Oct. value - Nov. value
      Delta December for PF-10329438 = Nov. value - Dec. value

      another example
      PF-XXXXX only have recored in Apr. 2023 ==> to be excluded from formual as long as there are no other records for that project in the list, but next moth if the project "PF-XXXXX" get another record,
      so
      Delta May for PF-XXXXX = Apr. value - May value