Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return Value based on two text conditions

Hi,   This maybe a very simple solutions, but currently I have a table like below with some sample data; ID Budgeted Cost Type Period Value Date 0101 null Capex FY20 PE11 - Feb 20 4...
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Guys

     

    One thing I ommitted previously was that there was a slicer that singled some results to a particular period. 

     

    This calculation was taking the whole period, and I added the ALL() funtion to the end looking up the date table, By adding the ALL() funtion straight after the SUM() meant I got the solution I was looking for.

     

    Thank you so much for all your efforts in helping, all of the information provided has been useful!

     

    All the best, and happy data naughting!

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Anonymous ,

 

Have you tried the if statement?

Capex Total TD = IF(MAX(Table[Type]) = "Capex"&&MAX(Table[Period]) = "Total",[measure])

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Liang, 

Thanks for you're answer, Howvever I am still getting no results from this solution. 

 

I'm really stuck at an impass here!