How to derive Quarter over Quarter values for current and previous month?

[Anonymous]

Hi All,

Can anyone please help me in deriving Quarter over Quarter values for current and previous month without filtering Date/Month/Year for Current DateTime? I am able to derive the all previous quarter values as can be seen from the below screenshot, however would only like to have values for current and previous quarter which would be '0' and '2884'. I would not like the other values to appear or cumulate.

The DAX Code written by me is as below:

Thanks in advance.

[v-henryk-mstf]

Hi @Anonymous ,

You can try to add an if function as a judgment condition. As follows: 

result = if( table[date] = ***,[loadsQoQ],if( table[data] = ***,[loadsQoQ0],0))

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[Anonymous · Accepted solution]

Hi Henry,

Thanks for reverting. However, I managed resolving my query with the below.

[v-henryk-mstf]

Hi @Anonymous ,

That is great! You can mark yourself answer as the solution to help the other members find it more quickly.🙂

Best Regards,
Henry