Forum Discussion

Carnage's avatar
Carnage
Frequent Visitor
8 years ago
Solved

Help with DAX formula

Hi All,   I have a problem that seems relatively easy to solve but I can't seem to formulate the correct DAX expression. Here's what I'm trying to accomplish:   Table 1 contains transaction data ...
Need Help
  • afzalphatan's avatar
    afzalphatan
    8 years ago

    Hope the below calcualted column formula help....

     

    Mark the ans if ur requirement is met. 

     

afzalphatan's avatar
afzalphatan
Resolver I
8 years ago

Hi, 

 

We can achieve ur requirement through Excel array and also DAX formula....

 

If your data set is small you can go for Excel Array formula... Below Pic has the formula (do not forget to press Ctrl+Shift+Enter)

 

 

 

We can also author DAX formula.....let me know if Array formula isn't enough for you data set.. I shall help with DAX formula 

Carnage's avatar
Carnage
Frequent Visitor
8 years ago

Thank you both for your replies.

 

afzalphatanI am grateful for your solution in Excel, but my dataset is very large and would need to be run through PowerBi. What would the formula look like in DAX? Thanks again