<div>
What if you start with a new column in your Date Table that shows the financial week of the year? &nbsp;Something like:<br><br>WeekNumber = WEEKNUM(Dates[Date]-90,1)<br><br>Then I would think the rest is just a mathematic calculation.<br><br><br>
</div>


What if you start with a new column in your Date Table that shows the financial week of the year?  Something like:

WeekNumber = WEEKNUM(Dates[Date]-90,1)

Then I would think the rest is just a mathematic calculation.




<div>
Hi Tom, do you think this might work without the need for touching the date table ? Thanks<br><br>Measure 2 = DIVIDE(MeasureA, 14 - WEEKNUM(TODAY()))<br>Measure 3 = DIVIDE(MeasureA, 52 - WEEKNUM((TODAY())) + 14)
</div>


Hi Tom, do you think this might work without the need for touching the date table ? Thanks

Measure 2 = DIVIDE(MeasureA, 14 - WEEKNUM(TODAY()))
Measure 3 = DIVIDE(MeasureA, 52 - WEEKNUM((TODAY())) + 14)

IT Consultant

gvamsimba

<div>
<div class="content wysiwyg-content fr-view">
Hi I have a measure 1 . I need to create 2 measures with the below formula. our Financial year is April 1 - March 31st. <br><br>Measure 2 = MeasureA Divided by Number of weeks LEFT in the Financial year<br><br>Measure 3 = MeasureA Divided by Number of weeks FINISHED in the Financial year<br><br>can someone please give that Dax formula for me ?
</div>
</div>



Hi I have a measure 1 . I need to create 2 measures with the below formula. our Financial year is April 1 - March 31st.
Measure 2 = MeasureA Divided by Number of weeks LEFT in the Financial year
Measure 3 = MeasureA Divided by Number of weeks FINISHED in the Financial year
can someone please give that Dax formula for me ?

dax divide by number number of weeks left in the financial year

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.