Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am having difficulties in creating a formula for date columns.
I have two different date columns:
What I would like to do is create another basic data changed column, where there is not presented dates that are bigger than posting data changed dates on a row. They can be presented with just null or something like that.
Could you please help me?
Best regards,
Kelly
Solved! Go to Solution.
If i understand ur requirement corrently...
If (Table1[Basic data changed] <= Table1[Posting data changed], Table1[Basic data changed], Blank())
Not clear .. can you please give the pic of sample data and the expected result..
I would like to get a new column, where are the same values as basic data changed column's values with one exception - if the basic data changed date is after posting data changed date, the result would be null.
Kelly
If i understand ur requirement corrently...
If (Table1[Basic data changed] <= Table1[Posting data changed], Table1[Basic data changed], Blank())
Thanks! This seems to be working.
Best regards,
Kelly
Is there anyone who could help me with this formula?
I tried to make with IF function, but that did not work. Maybe I just did not create it well.
Waiting for your kind solutions,
Kelly
My logic would tell me to create below seen formula, but this does not work for some reason.