topic Re: make variable constant in DAX Commands and Tips

make variable constant

giuliapiazza94 — Thu, 29 Apr 2021 15:33:23 GMT

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 — Thu, 29 Apr 2021 15:38:12 GMT

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 — Fri, 30 Apr 2021 06:52:26 GMT

Thank you so much 😁

I didn't understand how it works 😅