Repeat Quarter Total Per Month

DAX DAX Calculations
1

Good Day EDNA - help would be appreciated with this current measure. Looking to repeat the Quarterly number every month. must perform calculation with the number. found a few examples online. but it’s not working for me in the current qtr. on 2023.

Expecting to repeat the number in yellow, for each month in the right most column.

image
image793×733 55.5 KB

Below are the two measures.

Actual Rounded = SWITCH(TRUE(),
[Actual]>=4.3,4.4,
[Actual]>=4.2,4.3,
[Actual]>=4.1,4.2,
[Actual]>=4.0,4.1,
[Actual]>=3.9,4.0,
[Actual]>=3.8,3.9,
[Actual]>=3.7,3.8,
[Actual]>=3.6,3.7,
[Actual]>=3.5,3.6,
[Actual]>=3.4,3.5,
[Actual]>=3.3,3.4,
[Actual]>=3.2,3.3,
[Actual]>=3.1,3.2,
[Actual]>=3.0,3.1,
[Actual]>=2.9,3.0
)

Actual Rounded Qtr. = 
CALCULATE (
    [Actual Rounded],
       ALLEXCEPT( 'Calendar','Calendar'[WE YrQtr] )
     
    )

As always , thank you for your help in Advance!

FranKee.

2

Hi @Frankee ,

I noticed you didn’t provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.

A perfect initial question includes all of the following:

  • A clear explanation of the problem you are experiencing
  • A mockup of the results you want to achieve
  • Your current work-in-progress PBIX file
  • Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)

Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Not completing your data may sometimes cause delay in getting an answer.

Thank you!

3

Bumping this post for more visibility from our experts and users.

HI @Frankee ,

While waiting for other members to jump in, I suggest using the forum search to discover if your query has been asked before by another member.

Thanks!

4

Hi @Frankee - Can you share the PBIX file.

Thanks
Ankit J

5

Resolved for now. I’ll wait until the qtr ends. that could be the trouble.

thanks for the help here.

1 Like