Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Problems with Intelligence Measures Time

Good morning, I have a dashboard where I use the automatic YoY and MoM time intelligence measures. When I take part-time periods, that is, for example, the advance of the current month, the measures ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JosefinaMoneta ,

I am a little bit puzzled because I created my own test data for testing based on the DAX you provided, but I found that your DAX works perfectly fine, here are my test results:
Sample data:

Relationship:


I use the same DAX as you provide:


But the Output is right:

 

（(4+4+4+4)-(2+2+2+2））/（2+2+2+2）=100%

 

 

（（4+4+4+4+4）-（2+2+2+2+2+2+2））/（2+2+2+2+2+2+2）=42.857%

 


If you can, could you please provide us with your sample data, without it it is simply impossible to see which side has the problem with DAX alone.

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