Developer

Murray Brown

<div>
<div class="content wysiwyg-content fr-view">
<p>Hi. The following Power BI DAX statememt is a little confusing.</p><p>Why are there 2 equals signs</p><p><br></p><pre><code class="code-1 nolinks" id="code-10-29227458-1">TOTAL SALES 2019 =&nbsp;var&nbsp;currentyear&nbsp;=&nbsp;SELECTEDVALUE('CALENDAR'[Year],year(today()))&nbsp;return&nbsp;CALCULATE([TOTAL SALES],'CALENDAR'[Year]=currentyear-2)&nbsp;<br id="isPasted">
</code></pre>
</div>
</div>



Hi. The following Power BI DAX statememt is a little confusing.
Why are there 2 equals signs
TOTAL SALES 2019 = var currentyear = SELECTEDVALUE('CALENDAR'[Year],year(today())) return CALCULATE([TOTAL SALES],'CALENDAR'[Year]=currentyear-2) 


Power BI DAX Two Equals signs


Hi. The following Power BI DAX statememt is a little confusing.
Why are there 2 equals signs
TOTAL SALES 2019 = var currentyear = SELECTEDVALUE(&#39;CALENDAR&#39;[Year],year(today())) return CALCULATE([TOTAL SALES],&#39;CALENDAR&#39;[Year]=currentyear-2) 


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.

Power BI

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.