-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
meassures
-
S
Need help finding current quarter in a non January start.
Hi, I'm trying to create a DAX formula to figure out the current QUARTER. Below are a few of my attempts. Our year starts Feb 1 to Jan 31. =if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"") QTR =if(ROUNDUP((MONTH(TODAY())-1)/3, 0)=0,4) So...- shophoney
- Thread
- dax meassures power pivot
- Replies: 2
- Forum: Power Tools
-
R
DAX Measure to Countif on Measure Result in condition
I am struggling with DAX Measure to Countif on Measure Result in condition. Count of Items whose result of Measure4 = 0 for the selected Sales Centre and Month (YearMonthNumber). I am trying with this measure =CALCULATE (COUNTA (Data [Item Name]), FILTER(ALL('Data'), [QualificationUpto20] = 0))...- Ramzan11b
- Thread
- dax excel power query meassures
- Replies: 0
- Forum: Power Tools
-
D
DAX running total measures best practice
Hello, I was looking at different ways of dealing with a running total and I wondered if anyone had any advice on benefits of problems with different methods with regards to efficiency on large data sets which I don't deal with but it would be good to know. RTM := VAR mdate = MAX (...- dicken
- Thread
- dax meassures running total
- Replies: 0
- Forum: Power Tools
