Forum Discussion
giuliapiazza94
5 years agoHelper IV
make variable constant
Hi guys, I have a problem. In selectedvalue "Ultimo reload" isn't a constant, so DATATABLE doesn't work.
Does exist a method to "convert" or save a variable costant?
Misura =
VAR UltimoReload = SELECTEDVALUE(Diagnostica[Ultimo reload])
VAR AnnoUltRel = YEAR(UltimoReload)
VAR MeseUltRel = FORMAT(UltimoReload,"MM/YYYY")
VAR NuovaTab =
DATATABLE("RifData",DATETIME,"RifMese",STRING,"RifAnno",INTEGER,{
{UltimoReload,MeseUltRel,AnnoUltRel}
})
RETURN NuovaTab
)
thank you all
Even if you could put a variable in your DATATABLE, a measure can only return a single value, not a table, so you'd still have a problem.
2 Replies
- AlexisOlsonSuper User
Even if you could put a variable in your DATATABLE, a measure can only return a single value, not a table, so you'd still have a problem.
- giuliapiazza94Helper IV
Thank you so much 😁
I didn't understand how it works 😅