Forum Discussion

SebaSpotti's avatar
SebaSpotti
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Empty selectvalue eve if is not empty

Hi guys! I have this calculate table:  Last12Month = VAR ___Date = SELECTEDVALUE(MonthDate[Month]) VAR ___StartDate = DATE(YEAR(___Date),MONTH(___Date),1) //VAR ___StartDate = TODAY() VAR DateTab...
Need Help
dk_dk's avatar
dk_dk
Icon for Super User rankSuper User
1 year ago

Hi SebaSpotti 

Calculated tables are evaluated with data refresh, so SELECTEDVALUE will not work this way. (I assume your intention was that when you change the slicer selection for Month, the calculated table recalculates with that month, which is not possible)

See these previous threads for proposed workarounds:

https://community.fabric.microsoft.com/t5/Desktop/Calculated-Table-using-SELECTEDVALUE/m-p/911501
https://community.fabric.microsoft.com/t5/Desktop/Using-SELECTEDVALUE-with-Calculated-Table-workaround/td-p/1362430