Calculating Between 2 dates over 2 months
Hello All! I am trying to calculate days in each month from a start date and End date that spans over 2 or 3 months. I can get the dates correct for each project just by calculating the difference between dates but i am not able to look at how many days are in each month graphically. Is there a way to add a colum or measure to show how many days are in each month or is there a way to graph how many days are in each month when it is 2 or 3 different months? Thank you All! Pbreslin
Add days to a Date-measure
Hello everyone, I'm facing a problem. I would like to calculate a date with a measure, but it doesn't work, if I want to visualize it in a table. If I visualize it in a card, it works. Final Date = IF(MAX(Table1[Date1])>MAX(Table1[Date2]),MAX(Table1[Date1],MAX(Table1[Date2])+Table1[Measure of calculated days, which should] My goal is, to visualize it in a table-visual like this: customer Final Date A 6/15/2021 B 5/12/2021 Thank you! Kind regards MichaelDays between dates with nulls and blanks
Hello all, I have a table with three columns: Seniority date, Hire date and data date. I'd like to calculate the days/years between Seniority date and data date, however, the Seniority date column contains blanks and nulls along with actual dates. If a given line contains either a blank or null for seniority date, then I want to look at Hire date and apply the same logic. If Hire date contains a blank or null, then return a blank in the field for SenYrs. The below attempt at the code says there are no syntax errors but I get an error at runtime stating "The name 'isblank' wasn't recognized'. Any help or ideas would be appreciated. if(not(isblank[Seniority Date])) or [Seniority Date]<>null then ([data date]-[Seniority Date])/365.25 else if(not(isblank[Hire Date])) or [Hire Date]<>null then ([data date]-[Hire Date])/365.25 else blank()
