Forum Discussion

fab196's avatar
fab196
Helper II
4 years ago
Solved

dax date parameter

hi everyone, need your help i have table having two dates column both are important and i want use that id  loc ack date ship date 1 mumbai 8/10/2021 9/10/2021 1 guj 11/10/2021 1...
Need Help
Show and Tell
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi fab196 ,

     

    According to your description, a separate date column is created without creating a relationship between the tables. The measure created is used to count the number of locs under the selected date.

    I did a test reference as follows:

    M =
VAR sel_data =
    SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[ack date] = sel_data )


    If the problem is still not resolved, please provide more 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.

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

Hi fab196 ,

 

The sql code and dax have different calculation logic and cannot be directly converted based on the code you provided.

 

Does the solution given above meet your requirements, if there are still problems, please provide clear information about your requirements and screenshots of the expected results, I will answer you as soon as possible.


Best Regards,
Henry


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