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.
Hi all,
The date in my table is stored in the format "mm--dd--yy" as shown in the picture. When I wrote a measure as "CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] <= 1/1/2018)", I got no data showing up. And the latest date stored is 1/1/2018. However, when I did "CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] > 1/1/2018)", I got all the data I want.
Does anyone have any thoughts about what's happening?
Best,
Yilin
Solved! Go to Solution.
@pandakillsalot,
Change your measure to the following:
CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] <= DATE(2018,1,1))
Regards,
Lydia
@pandakillsalot,
Change your measure to the following:
CALCULATE(DIVIDE(StressProduction[NumberPassesCorrect],StressProduction[Unique SN count],0), DateTable[Date] <= DATE(2018,1,1))
Regards,
Lydia
Covering 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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |