I have a question about calculating the days between two dates. I have a table with a column for the record create date and I need to calculate the # of days this record has been in the table through today. My question is, should I add a column and use DATEDIFF or should I use DATEDIFF in an itera…

Hello @patrickcox … Sorry if I am late on this. My understanding is that unless you plan to use “no. of days” on a slicer, you can very well use measures. I mean measure is the best practice if you do not intend to slice your visulizations by the “no. of days”. Reference: Power BI Calculated Colu…

Measure vs Calculated Column for DATEDIFF Calculation

DAX DAX Calculations

EnterpriseDNA February 22, 2022, 1:52am 4

Hello @patrickcox I suggest using the forum search to discover if your query has been asked before by another member.

You may want to check out the threads below as well: