topic Value for current Fiscal Month regardless the filter in DAX Commands and Tips

Value for current Fiscal Month regardless the filter

joshua1990 — Thu, 20 Aug 2020 17:15:06 GMT

Hello everyone!

I have a matrix with different measures.

In total there are 5 measures. 4 measures based on the current fiscal week. For this purpose I have a filter on this visual with the current month (TRUE/ FALSE). The last measure should sum up all values for the current MONTH.

But how is this possible, since I have a filter for the current week for the visual?

The measure is something like SUM ( Sales[Sales]).

I allready have the current month column in the calendar. Our fiscal months have specific start and end dates - if this is a useful information.

Best Regards

Re: Value for current Fiscal Month regardless the filter

Anonymous — Thu, 20 Aug 2020 17:23:33 GMT

Hi joshua1990 ,

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Can you share some sample data or screenshots of your visualization.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: Value for current Fiscal Month regardless the filter

Anonymous — Sat, 22 Aug 2020 10:25:18 GMT

// Assumptions: // You've got a stand-alone Calendar table // that is a date table marked as such // in the model. [Base Measure] is the // measure you want to calculate over // the current month. 'Calendar'[Current Month] // is a TRUE/FALSE field in Calendar // marking with TRUE the days that belong to // the current (fiscal?) month. [Base Measure for Current Month] = CALCULATE( [Base Measure], 'Calendar'[Current Month], ALL( 'Calendar' ) )