Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

week

hiii i want display my data per weeks  previously to represent data in months i used the below formula   Table = ADDCOLUMNS ( FILTER ( VALUES ( Query1[Call Closed] ), [Call Closed] <> BLANK (...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I’m not very sure about your requirement…Maybe you want to display weeknum?

WeekNum =

WEEKNUM ( 'Query1'[Call Closed], 2 )

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin