Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter depending on values

Hi guys: I have accounting periods with date/time format. When the period is closed the format is "dd/mm/yyyy hh:ss" with the last day, for example "31/10/2020 12:00" and when we need to add some ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Is this what you want? Please download the PBIX file for details. Let me know if you have any questions.

     

    Best Regards,
    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Not ver clear but column like

if([datetime].time = time(0,0,0) , [datetime], blank())

 

or

 

if([datetime].time = time(1,0,0) , [datetime], blank())

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, thank you for your help. I am so sorry that I did not explain correctly.

    I think that I need a measure, because I need the filter result on this table (let me paste it again, cause I see that the columns are so close):

     

    My dates will be every final date of each month, plus the "12:00". In some cases I will have this date + "12:00" and, also, the same final date of the month, plus 1:00.

    I need in this filter option A and option B. When A is selected I should have all the dates rows with the "12:00", but when I have the B filter, I should have only all the dates with "12:00" BUT in the cases when I have the same 2 dates (one with "12:00" and the other with "1:00"), excludes the one with "12:00", and shows the date with "1:00" and the dates that just have "12:00" show them to. 

    That is why, in my table example, the A have just dates with "12:00" and in B I have a mix of "12:00" and "1:00".

     

    I hope I have explained myself better