dax | formatting issue in calculation group

[hood2media]

hi,

as an intro, i have been using tabular editor 2 for some time to create calculation groups especially for time intelligence for without any issue. however, just today i found that there's an issue with format string expression where i'm not getting the numbers to be displayed as requested. 

as an example, before i get the display for yoy% to be correct as follows

now, i get the incorrect values for yoy%

i have also tried using the preview version of the 'native' calculation group function in power bi desktop but i'm also not getting the correct reading (in fact the ordinality of the columns also is affected despite correcting it manually). 

what seems to be the issue & how can this be resolved?

tks & krgds, -nik 

[v-zhangti · Accepted solution]

Hi, @hood2media 

You can try the following methods.
Measure:

Previous Year = 
Var _year=MAXX(FILTER(ALL('Table'),[Year]<SELECTEDVALUE('Table'[Year])),[Year])
Var _value=CALCULATE([Current],FILTER(ALL('Table'),[Year]=_year))
Return
_value

YoY = IF([Previous Year]=BLANK(),BLANK(),[Current]-[Previous Year])

YoY% = DIVIDE([YoY],[Previous Year])

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @hood2media ,

Without more information is difficult to pin point your issue.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[hood2media]

dear @MFelix & @v-zhangti,
many thanks for the interest to help.

i have managed to solve the (weird) problem. may be there was certain conflicts that caused the initial problem that is now gone & all is back to normal.

krgds, -nik