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.

parry2k's avatar
parry2k
Super User
4 years ago

fab196 doesn't make sense what you are looking for. why you want the union and set values to zero, it will return two rows, how you will visualize it? What you are trying to do? The answer I provided earlier gives you a count based on the selected date, not sure why you want two rows with 0 values.