https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Relevant-Calculations/m-p/1749579#M36430 <P>I have identified these kpi's:</P><P><EM>Age of inovices unpaid, because unpaid invoices may attract any penalty ( few vendors may do so)</EM></P><P><EM>Number of invoices by BU / By Age (Paid and Unpaid)</EM></P><P><EM>Paid invoices Age when the get paid</EM></P><P>for this data see:&nbsp;<A href="https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing" target="_blank" rel="noopener nofollow noreferrer">https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing</A></P><P>&nbsp;</P><P>Please adise what calculations/dax would be relevant?</P> Sat, 27 Mar 2021 19:28:51 GMT Yrstruly2021 2021-03-27T19:28:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Relevant-Calculations/m-p/1749579#M36430 <P>I have identified these kpi's:</P><P><EM>Age of inovices unpaid, because unpaid invoices may attract any penalty ( few vendors may do so)</EM></P><P><EM>Number of invoices by BU / By Age (Paid and Unpaid)</EM></P><P><EM>Paid invoices Age when the get paid</EM></P><P>for this data see:&nbsp;<A href="https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing" target="_blank" rel="noopener nofollow noreferrer">https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing</A></P><P>&nbsp;</P><P>Please adise what calculations/dax would be relevant?</P> Sat, 27 Mar 2021 19:28:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Relevant-Calculations/m-p/1749579#M36430 Yrstruly2021 2021-03-27T19:28:51Z