topic Re: Power Pivot Measure to calculate days between two dates for each category in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot-Measure-to-calculate-days-between-two-dates-for-each/m-p/3929849#M152895 <P>If you want to keep your data in Excel you will have to hard code the order of the column checks.</P> <P>&nbsp;</P> <P>In Power BI we would ask you to unpivot your data, and to provide a reference table with the stage sequence index.</P> Sat, 18 May 2024 19:46:08 GMT lbendlin 2024-05-18T19:46:08Z Power Pivot Measure to calculate days between two dates for each category https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot-Measure-to-calculate-days-between-two-dates-for-each/m-p/3928331#M152843 <P>I hope I am in the correct forum. I have an excel table that I have loaded into my data model. The topic is, say butterflies.</P><P>The "Stage" column is a calculated column using an If statement and based on the last isblank cell. What I would like to do is to write a measure that calculates the StageDays based on Stage--which would be today - the last filled-in-date. Can you help me figure out how to do this? Thanks.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Specimen</TD><TD>EggDate</TD><TD>LarveDate</TD><TD>PupeDate</TD><TD>Stage</TD><TD>StageDays</TD></TR><TR><TD>01245</TD><TD>4/6/2023</TD><TD>5/7/2023</TD><TD>6/3/2023</TD><TD>Pupe</TD><TD>&nbsp;</TD></TR><TR><TD>0357</TD><TD>2/4/2023</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Egg</TD><TD>&nbsp;</TD></TR><TR><TD>0934</TD><TD>2/9/2023</TD><TD>5/6/2023</TD><TD>&nbsp;</TD><TD>Larve</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Fri, 17 May 2024 19:28:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot-Measure-to-calculate-days-between-two-dates-for-each/m-p/3928331#M152843 enmnm 2024-05-17T19:28:31Z Re: Power Pivot Measure to calculate days between two dates for each category https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot-Measure-to-calculate-days-between-two-dates-for-each/m-p/3929849#M152895 <P>If you want to keep your data in Excel you will have to hard code the order of the column checks.</P> <P>&nbsp;</P> <P>In Power BI we would ask you to unpivot your data, and to provide a reference table with the stage sequence index.</P> Sat, 18 May 2024 19:46:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot-Measure-to-calculate-days-between-two-dates-for-each/m-p/3929849#M152895 lbendlin 2024-05-18T19:46:08Z