make variable constant

[giuliapiazza94]

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

[AlexisOlson · Accepted solution]

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.

[giuliapiazza94]

Thank you so much 😁 

I didn't understand how it works 😅