Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
i am currently using this DAX as a calculated column to return the previous periods usertotal:
Prev_Date =
VAR CompanyID = table[companyId]
VAR Date1 = table[Date]
VAR Pre_Date = CALCULATE(MAX(table[Date]),FILTER(table,table[companyId]=CompanyID),FILTER(table,table[Date]<Date1))
VAR Prev_Val = CALCULATE(MAX(table[UsersTotal]),FILTER(table,table[companyId]=CompanyID),FILTER(table,table[Date]=Pre_Date))
RETURN IF(Prev_Val=BLANK(),0,Prev_Val)
What I would like to do is adjust this DAX to return the prevous period date rather then the user total
How can I adjust this DAX to return the prevous Date?
Solved! Go to Solution.
Why can't you just return the Pre_Date variable? It seems you've already calculated it. Just chang the last line to Pre_Date and get rid of the IF() statement.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingWhy can't you just return the Pre_Date variable? It seems you've already calculated it. Just chang the last line to Pre_Date and get rid of the IF() statement.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI literally did that and it didnt work, I just retried and it worked thank you
Excellent! Probably some comma or space messing it up the first time you tried.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |