Forum Discussion

mohammadyousaf's avatar
mohammadyousaf
Resolver II
4 years ago
Solved

Getting dates from different tables into main tables

Hi, can someone please help me with a dax..   I have imported data from SQL and there are more than 80 tables.. the sample is like this Table 1 Task ID Task Name Star Date End Date  1 A...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi mohammadyousaf ,

     

    According to your description, refer to the following formula whether it can meet your needs.

    M_min = 
CALCULATE (
    MIN ( Table_dimension[Date] ),
    FILTER ( ALL ( Table_1 ), Table_1[Catesgory] = MAX ( Table_1[Catesgory] ) )
)

M_max =
CALCULATE (
    MAX ( Table_dimension[Date] ),
    FILTER ( ALL ( Table_1 ), Table_1[Catesgory] = MAX ( Table_1[Catesgory] ) )
)

    If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your feedback.


    Best Regards,
    Henry


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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi mohammadyousaf ,

 

According to your description, refer to the following formula whether it can meet your needs.

M_min = 
CALCULATE (
    MIN ( Table_dimension[Date] ),
    FILTER ( ALL ( Table_1 ), Table_1[Catesgory] = MAX ( Table_1[Catesgory] ) )
)

M_max =
CALCULATE (
    MAX ( Table_dimension[Date] ),
    FILTER ( ALL ( Table_1 ), Table_1[Catesgory] = MAX ( Table_1[Catesgory] ) )
)

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your feedback.


Best Regards,
Henry


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