Forum Discussion
Previous day value - SSAS Tabular live connection
Hi , Anonymous
Please refer to these related threads.
https://community.powerbi.com/t5/Desktop/Alternative-of-SELECTEDVALUE-DAX-function/m-p/812261
You can take a try to use IF + HASONEVALUE combination to replace the" selectvalue" function in DirectQuery mode.
IF（HASONEVALUE（Table [column]），VALUES（Table [column]））Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi , Anonymous
You may check if the following formulas help:
Previous O/S measure =
CALCULATE(
SUM(Test[Outstanding]),
FILTER(
ALL(Test),
Test[Business_Date]=SELECTEDVALUE(Test[Business_Date])-1
)
)flag =
IF(
ISBLANK([Previous O/S measure]),
1,0
)
Result = SELECTEDVALUE(Test[Outstanding])-[Previous O/S measure]
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Eason v-easonf-msft
Thanks a lot for your reply.
I am using SSAS Live connection. So SELECTEDVALUE function is not working. Even EARLIER function is givnig errors.
I get "SELECTEDVALUE" is not a function.
I referred to this Post - https://community.powerbi.com/t5/Desktop/SELECTEDVALUE-not-a-valid-function/td-p/270639 which is an old post.
Can you suggest any other alternate for my case?
Thanks
Manoj
- v-easonf-msft
Hi , Anonymous
Please refer to these related threads.
https://community.powerbi.com/t5/Desktop/Alternative-of-SELECTEDVALUE-DAX-function/m-p/812261
You can take a try to use IF + HASONEVALUE combination to replace the" selectvalue" function in DirectQuery mode.
IF（HASONEVALUE（Table [column]），VALUES（Table [column]））Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.