Forum Discussion

ChubbChubb's avatar
ChubbChubb
Helper I
2 years ago
Solved

DAX formula not working

I'm triyng to add a subtitle to acard to display national data.   The formula that works looks like this  KPI Attendance Target = format(Product('Academy Info'[Attendance Target]),"KPI #%"&""). I...
Need Help
  • olgad's avatar
    olgad
    2 years ago

    Hi, dont place NAT  into format function

     "Nat " & format(Product('Academy Info'[Attendance Target]," #%"&"")
olgad's avatar
olgad
Resident Rockstar
2 years ago

Hi, dont place NAT  into format function

 "Nat " & format(Product('Academy Info'[Attendance Target]," #%"&"")
ChubbChubb's avatar
ChubbChubb
Helper I
2 years ago

Thank you for that, I had copied the forumla from somewhere else so wasn't sure on it. Do you know why it was replacing the letters for number?