https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formel-who-sum-up-the-column-with-data-only-for-quot-today-quot/m-p/1732575#M35919 <P>Hi</P><P>&nbsp;</P><P>I need a formel who can sum up the column data - but only for the date "today"</P><P>I have tried quick measure but I do not have "today" as an option:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Can anybody help me? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>Best regards</P><P>Elena Johansen</P><P>&nbsp;</P> Fri, 19 Mar 2021 10:28:52 GMT Anonymous 2021-03-19T10:28:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formel-who-sum-up-the-column-with-data-only-for-quot-today-quot/m-p/1732575#M35919 <P>Hi</P><P>&nbsp;</P><P>I need a formel who can sum up the column data - but only for the date "today"</P><P>I have tried quick measure but I do not have "today" as an option:</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Can anybody help me? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>Best regards</P><P>Elena Johansen</P><P>&nbsp;</P> Fri, 19 Mar 2021 10:28:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formel-who-sum-up-the-column-with-data-only-for-quot-today-quot/m-p/1732575#M35919 Anonymous 2021-03-19T10:28:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formel-who-sum-up-the-column-with-data-only-for-quot-today-quot/m-p/1732896#M35937 <P>Anonymous</LI-USER> , You can create a meausre like </P> <P>&nbsp;</P> <P>calculate(sum(Table[Value]), filter(Table, Table[date] =today()))</P> Fri, 19 Mar 2021 12:57:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formel-who-sum-up-the-column-with-data-only-for-quot-today-quot/m-p/1732896#M35937 amitchandak 2021-03-19T12:57:29Z