DAX error support - True/False
I am trying to create a DAX formula that will count the number of students on roll in a school last school year specifically on 2MAY24. Gemini has offered the below but I'm getting a The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column error. KH Students on Roll 23/24 = CALCULATE ( COUNTROWS ( ACADEMIC_CALENDAR_DATES ), ACADEMIC_CALENDAR_DATES[STUDENT_ON_ROLL] = TRUE, ACADEMIC_CALENDAR_DATES[STUDENT_ON_ROLL] = "May", HASONEVALUE ( STUDENT_SCHOOL_ENROLEMENTS[CURRENTLY_ON_ROLL] ), STUDENT_SCHOOL_ENROLEMENTS[CURRENTLY_ON_ROLL] = TRUE ) I'm a real beginner to DAX so not quite sure how to get it to count just for May. Any ideas ??
Help with Formula for Days in AR
Hello! Good Afternoon. I am needing some help with a formula for showing casing the # of Days in AR. Below you will find all the formulas I used inside of my report. I also have provided several screenshots. I am not sure what I am doing wrong. Please help!!!! My teammates are getting frustrated with me. 😞 I can't figure it out. Thank you so much in advance! Sincerely, Amanda Last 6 Month Charges = 1,689,901.39 How I got the Last 6 Month Charges is by using the Date (relative date) filter. I also had a formula called IsLatest ..that is a True / False statement set up to only sum charges by latest modified date so it wouldn't be adding up duplicate values. Count of Days in Last 6 Months = 184 I used my Calendar Table and chose the column “Days in Month.” I then used the Date Filter to only count the days in the last 6 months. Average Charges in Last 6 Months = 8,966.86 I then set up a measure to calculate the Average Charges by dividing the Last 6 months charges by the # number of days in last 6 months. I also applied the date filter for the last 6 months. DAX FORMULA USED: Avg Charges = DIVIDE([Last 6 month Charges], COUNT(_Calendar[Days in Month]),0) Total AR = 593,560.15 I just used my Charges Table and Chose "Balance" Total AR Days = 66 ($ 59, 3560.15 Total AR / $ 8,966.86 Average Charge in last 6 months) *****When setting up this formula I get the following value = 45 Using dax formula = AR Days = DIVIDE([Total Balance],[Avg Charges], 0)
Dynamic Measure that assigns a revenue grouping based on current selection?
Hello all, I create a custom column with using a switch function (below) It works fine within the table, but when they are filtered by year, date, product type, and several other filters, they are no longer accurate as to its range. I think this is because the column created is on a per row basis, and it displays the first range from its list when summarized below. I am thinking that a measure that will dynamically change based on the current revenue total showing is superior to a calculated column. Is there a way to do this? Here is the syntax for the column created: Revenue Range = SWITCH(TRUE(), 'Data'[Revenue ($k)]<500000, "<500K", AND('Data'[Revenue ($k)]>=500000, 'Data'[Revenue ($k)]<1000000), "500K-1M", AND('Data'[Revenue ($k)]>=1000000, 'Data'[Revenue ($k)]<2000000), "1M-2M", AND('Data'[Revenue ($k)]>=2000000, 'Data'[Revenue ($k)]<3000000), "2M-3M", 'Data'[Revenue ($k)]<3000000, "<Over 3M")
Calculate data from absolute measures
Hello, I cannot find a solution for a probably very simple question. I have a table with an absolute measure of a utility counter with the timestamp when it was measured e.g The key is that the measured value always goes up. What I would like to do is to find out information about the consumption eg how much has been consumed this month, what is the difference between months, average consumption per day etc. The timestamps are quite random and some might be missing.
