Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I have a simple measure that is supposed to return the previous days number for a count of apps that meet a certain criteria. At first, I tried this dax expression:
Apps previous day = Calculate(
count(data[app Number]), Previousday(date DIM [Date]))
This expression does not return an error, but it also does not return any values. I was able to get the measure to work properly by using:
Solved! Go to Solution.
@LeeI , The PREVIOUSDAY function is a time intelligence function that works with a date column to return a table containing the previous day. However, it requires a proper date context to function correctly.
Try using ALL function to remove any existing filter on dim[date]
Apps previous day =
CALCULATE(
COUNT(data[app Number]),
PREVIOUSDAY(ALL('Date DIM'[Date]))
)
Proud to be a Super User! |
|
@LeeI , The PREVIOUSDAY function is a time intelligence function that works with a date column to return a table containing the previous day. However, it requires a proper date context to function correctly.
Try using ALL function to remove any existing filter on dim[date]
Apps previous day =
CALCULATE(
COUNT(data[app Number]),
PREVIOUSDAY(ALL('Date DIM'[Date]))
)
Proud to be a Super User! |
|
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 9 | |
| 6 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 21 | |
| 14 | |
| 11 | |
| 5 | |
| 5 |