Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Simple calculation

Hi, all.   I wonder how to make a measure value in this case. I want to count the rowss of tablet A with filter about A,B,C. I want to calculate by applying a filter for the state of B and the ve...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    I noticed your last post, is it similar to this one, based on the data from the previous post, I created the following formula:

    diff = DATEDIFF(MAX('Table'[coupon_usedate]),MAX('Table2'[lastlinkdate]),DAY)
    count = COUNTX(FILTER( 'Table2',[diff]<=30&&[diff]>=0),[lastlinkdate])

     The final output is shown below:

    If not right ,could you share a simple file and share the result what you want to output?


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

I noticed your last post, is it similar to this one, based on the data from the previous post, I created the following formula:

diff = DATEDIFF(MAX('Table'[coupon_usedate]),MAX('Table2'[lastlinkdate]),DAY)
count = COUNTX(FILTER( 'Table2',[diff]<=30&&[diff]>=0),[lastlinkdate])

 The final output is shown below:

If not right ,could you share a simple file and share the result what you want to output?


Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.