Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Basically, if Date2 is blank then Age column should be blank because there is nothing to compare to.
DaysBetweenDates = IF(ISBLANK([Date1),BLANK(),([Date2] - [Date1)*1.)
I'm struggling correcting this formula
Column = IF(ISBLANK('Table1'[DaysBetweenDates]),BLANK(),IF(''Table1'[DaysBetweenDates]< 46,"< 45 Days","45+ Days"))
Thanks
Solved! Go to Solution.
I think you need to check both for blank before you make the calculation here:
DaysBetweenDates = IF(ISBLANK([Date2]),BLANK(),if(ISBLANK([Date1]),BLANK(),([Date2] - [Date1)*1.))
Then your 2nd one would work.
Hi @Stuznet
Shouldn't your first formula be the one below?
DaysBetweenDates = IF(ISBLANK([Date2),BLANK(),([Date2] - [Date1)*1.)
I can't see your data but the second formula is reliant on the first. Are you 100% sure the first formula is returning Blank()?
From your sample data the first formula may not return blank as Date1 is never blank and the so the 2nd part of the first formula will always execute which is Date2 - Date1?
Maybe add DaysBetweenDates to your table so you can see what this is actually returning as it clearly it isn't returning Blank().
It is calculating something eventhough Date2 is blank
I think you need to check both for blank before you make the calculation here:
DaysBetweenDates = IF(ISBLANK([Date2]),BLANK(),if(ISBLANK([Date1]),BLANK(),([Date2] - [Date1)*1.))
Then your 2nd one would work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |