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 info after this, we add a row with the same date, but 1 am, continuing with the same example "31/10/2020 01:00".
So, what I need in Power BI is put a filter that gives me 2 options "A" and "B",
A: allows me to have all the periods with the 12:00 and excluiding the ones with 1:00.
B: use the period when it have the 01:00 excluding the periods with 12:00, but when the period does not have 01:00 let the period with 12:00.
Something like this:
|Table||Filter A||Filter B|
|31/01/2020 12:00||31/01/2020 12:00||31/01/2020 01:00|
|31/01/2020 01:00||28/02/2020 12:00||28/02/2020 12:00|
|28/02/2020 12:00||31/03/2020 12:00||31/03/2020 12:00|
|31/03/2020 12:00||30/04/2020 12:00||30/04/2020 01:00|
Solved! Go to Solution.
Hi @eduardosilvin ,
Has this problem been solved? If so, kindly Accept the appropriate reply as the solution or post your own solution. People having similar questions will find it quickly. If not solved, share more info about how it is going now. Thanks.
@eduardosilvin , Not ver clear but column like
if([datetime].time = time(0,0,0) , [datetime], blank())
if([datetime].time = time(1,0,0) , [datetime], blank())
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.