Forum Discussion

giuliapiazza94's avatar
5 years ago
Solved

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

  • 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.