IT Consultant

gvamsimba

<div>
<div class="content wysiwyg-content fr-view">
Hi, I have table with custid, createddate and cancelled date. I want to create a calcualted measure using DAX for couting<br>number of custid's WHERE createdate is BETWEEN April1st - March31t financial year BUT EXCLUDE those custid's<br>WHERE cancelled date is BETWEEN April1st - March31t financial year.<br>&nbsp;<br><strong>Please note that I have a DATE table with just column called DATE which has dates until december 2099</strong><br><br>Can someone please help me with that DAX query ? Many Thanks<br><br>
</div>
</div>



Hi, I have table with custid, createddate and cancelled date. I want to create a calcualted measure using DAX for couting
number of custid's WHERE createdate is BETWEEN April1st - March31t financial year BUT EXCLUDE those custid's
WHERE cancelled date is BETWEEN April1st - March31t financial year.
 
Please note that I have a DATE table with just column called DATE which has dates until december 2099
Can someone please help me with that DAX query ? Many Thanks

DAX query for COUNT for YTD

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.