Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
im currently computing for gain/loss in the stock market, and the calendar is not perfect. for example today is monday, and i need to retrieve the data for friday. I am trying to do it in dax with date values, but i only have data for weekdays, nothing on weekends. hope it make sense. Anyone can help please and thanks in advance.
Solved! Go to Solution.
@SinclairFletche
Try this, replace source with the table name you have:
Gain / Loss =
VAR x = 'Historical Data'[DATE]
RETURN
CALCULATE(
MAX('Historical Data'[SOURCE),
FILTER(
ALL('Historical Data'),
'Historical Data'[DATE] < x
)
)
Hi Ray, okay i get the idea, thank you
Gain / Loss =
CALCULATE(
MAX('Calendar'[Date]),
FILTER(
ALL('Historical Data'[DATE]),
'Historical Data'[DATE] < MAX('Calendar'[Date])
)
)
mhmm, im just getting the same date instead of the previous day
what am i doing wrong?
@SinclairFletche
Try this, replace source with the table name you have:
Gain / Loss =
VAR x = 'Historical Data'[DATE]
RETURN
CALCULATE(
MAX('Historical Data'[SOURCE),
FILTER(
ALL('Historical Data'),
'Historical Data'[DATE] < x
)
)
working now. Thanks
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |