Forum Discussion

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
7 years ago

How to find a difference between two dates which has no relation???

Hi, Could someone please explain how to find a difference between two dates which has no relation?? I have two tables Project and opportunity which has no relation. I am using the below DAX Days ...
Need Help
Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
7 years ago

Hi,

 

This is not wokring where objects has no relation. I aleady tried this DAX, but it is not giving me the expected results.

I using direct query here on which I have no control. 

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Could you please share the pbix to us for analysis? In my environment, it works.

  • Amitkr174's avatar
    Amitkr174
    Icon for Helper III rankHelper III
    7 years ago

    I think the pbix file won't open at your end as it is connected to the SSAS cube whose access is restricted to the external users.