Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),DIM_DATE[Index]=177-1)
Measure 2dim = MAX(DIM_DATE[Current Index])-1
PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),DIM_DATE[Index]=[Measure 2dim])
Can somebody help with the above dax code? The first line does exactly what I need. How ever the value 177 is the index of the current week and I want to make this dynamic. Measure 2dim should give the same result as 177-1, however i'm getting the message:
How should I make the statement so that I get rid of the error. I'm trying to get the count of last week vulnerabilities.
Solved! Go to Solution.
@Kpham
Can you try the following modified measure:
PreviousWeekVulnerabilites =
var __date = MAX(DIM_DATE[Current Index])-1 return
CALCULATE(
SUM('FACT'[Count]),
DIM_DATE[Index]=__date
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi,
Does this measure work?
PreviousWeekVulnerabilites = CALCULATE(SUM('FACT'[Count]),filter(values(DIM_DATE[Index])=[Measure 2dim]))
@Kpham
Can you try the following modified measure:
PreviousWeekVulnerabilites =
var __date = MAX(DIM_DATE[Current Index])-1 return
CALCULATE(
SUM('FACT'[Count]),
DIM_DATE[Index]=__date
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
78 | |
54 | |
39 | |
35 |
User | Count |
---|---|
102 | |
84 | |
48 | |
48 | |
48 |